FUDforum: Database discussions » Total conversion of database to utf8

Home » General » Database discussions » Total conversion of database to utf8 (is it possible?)

Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic

Total conversion of database to utf8 [message #38474]

Wed, 08 August 2007 13:21

Shaltay

Messages: 6
Registered: July 2007

Karma: 0

Junior Member

add to buddy list
ignore all messages by this user

Hello.
This is my current settings (after installation):

use fudforum
Database changed
mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)

Can I fully convert database to utf8?
using mysqldump:
sv@server:~$ mysqldump --set-charset --default_character_set=latin1 fudforum -u root|sed "s~latin1~utf8~" >~/fudforum.dump

then creating another database with default charset utf8.
Changing in admincenter the database to new one, after that doing check consistency and SQL table optimiser
then look to "???????????" on index page.

What is wrong?

Report message to a moderator