mysql4.1以上數據庫的中文字符集的解決
在進入mysql控制臺后，用如下命令中設置字符集：
SET character_set_client=utf8
SET character_set_connection=utf8
SET character_set_database=utf8
SET character_set_results=utf8
SET character_set_server=utf8
SET collation_connection=utf8_bin
SET collation_database=utf8_bin
SET collation_server=utf8_bin
也可以在my.ini中的[mysql]中
CREATE DATABASE yourdatabasename
CHARACTER SET utf8
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci
DEFAULT COLLATE utf8_general_ci ;
mysql YourDatabaseName <**.sql
對于mysql命令導入mysql 數據庫的sql文件，需要加入參數：
--default-character-set=utf8 YourDatabaseName
mysql> show variables like "%char%";
| Variable_name | Value |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\your mysql home\share\charsets/ |
7 rows in set (0.00 sec)
show variables like "%col%";
| Variable_name | Value |
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| protocol_version | 10 |
4 rows in set (0.00 sec)
從4.0到4.1以上數據庫的遷移問題的解決。
用mysqldump 命令將數據庫導出4.0(-)的數據庫后，在4.1(+)的數據庫指定導入文件的字符集，即可。
mysqldump –p –where="Order_ID > 2000" Meet_A_Geek Orders > Special_Dump.txt
mysql --default-character-set=utf8 YourDatabaseName <preffixtemplate_block_history.sql