FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

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 
Return to the default flat view Create a new topic Submit Reply
Total conversion of database to utf8 [message #38474] Wed, 08 August 2007 13:21 Go to previous message
Shaltay is currently offline  Shaltay   Russian Federation
Messages: 6
Registered: July 2007
Karma:
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?
[Message index]
 
Read Message
Read Message
Previous Topic: UNABLE TO WRITE TO SQL LOG FILE
Next Topic: phpsyslogng error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 11 18:00:32 EST 2017

Total time taken to generate the page: 0.00649 seconds