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 13:21
Shaltay
Messages: 6Registered: 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?
Rate Topic
1 Worst
2
3
4
5 Best
Goto Forum:
- FUDforum FUDforum Documentation FUDforum Announcements FUDforum Installation Issues How To FUDforum Suggestions - FUDforum Development FUDforum 3.0+ Bug Reports Plugins and Code Hacks Converters Translations Forum Styles Icons & buttons Forum Showcase Marketplace - General General Chit Chat FUDforum in eGroupWare PHP discussions Database discussions HTML, Javascript, jQuery & AJAX Test Forum Test subforum 1 Test subforum 2 - Imported messages comp.lang.php
Current Time: Mon Apr 19 23:29:59 EDT 2021
Total time taken to generate the page: 0.00702 seconds