你查一查你数据库的字符集有没有完全设置好
mysql> show variables like "%char%";
+--------------------------+---------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\MySQL\mysql-5.0.21-win32\share\charsets\ |
+--------------------------+---------------------------------------------+
8 rows in set (0.01 sec)
mysql> show variables like "%char%";
+--------------------------+---------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\MySQL\mysql-5.0.21-win32\share\charsets\ |
+--------------------------+---------------------------------------------+
8 rows in set (0.01 sec)
但是不知道mysql是否支持UTF-8,你最好看一下API
开始-程序-MySQL-MySQL Server 5.0-MySQL Server Instance Config Wizard
直接下一步一下步,改成GBK
PostgreSQL还是用过的
那个也差不多
又有latin1、utf8、gbk
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | gbk |
| character_set_results | latin1 |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | D:\MySQL\MySQL Server 4.1\share\charsets/ |
+--------------------------+-------------------------------------------+
如何把latin1更改成utf8呢?
命令为:alter database db_name default character set gb2312;
default-character-set=gb2312
就OK了!