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 
Switch to threaded view of this topic Create a new topic Submit Reply
Total conversion of database to utf8 [message #38474] Wed, 08 August 2007 13:21 Go to next message
Shaltay is currently offline  Shaltay   Russian Federation
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?
Re: Total conversion of database to utf8 [message #38484 is a reply to message #38474] Thu, 09 August 2007 19:31 Go to previous message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The forum actually has a charset conversion tool built-in you can access via the admin control panel.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sun Dec 17 05:15:44 EST 2017

Total time taken to generate the page: 0.00676 seconds