Home »
General »
Database discussions »
Total conversion of database to utf8 (is it possible?)
Total conversion of database to utf8 [message #38474] |
Wed, 08 August 2007 17:21 ![Go to next message Go to previous message](/forum/theme/default/images/down.png) |
Shaltay
![Russian Federation Russian Federation](/forum/images/flags/ru.png) Messages: 6 Registered: July 2007
Karma:
|
Junior Member |
|
|
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?
|
|
|
Goto Forum:
Current Time: Mon Jun 17 00:38:04 GMT 2024
Total time taken to generate the page: 0.04751 seconds