mysql4.1以上數(shù)據(jù)庫的中文字符集的解決
在進(jìn)入mysql控制臺后，用如下命令中設(shè)置字符集：
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命令導(dǎo)入mysql 數(shù)據(jù)庫的sql文件，需要加入?yún)?shù)：
--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以上數(shù)據(jù)庫的遷移問題的解決。
用mysqldump 命令將數(shù)據(jù)庫導(dǎo)出4.0(-)的數(shù)據(jù)庫后，在4.1(+)的數(shù)據(jù)庫指定導(dǎo)入文件的字符集，即可。
mysqldump –p –where="Order_ID > 2000" Meet_A_Geek Orders > Special_Dump.txt
mysql --default-character-set=utf8 YourDatabaseName <preffixtemplate_block_history.sql