你查一查你数据库的字符集有没有完全设置好
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)

解决方案 »

  1.   

    连接字符串中加入charset = gbk;
      

  2.   

    貌似mysql里面的编码并不是支持中文的编码,要改成GBK 或是 UTF-8
    但是不知道mysql是否支持UTF-8,你最好看一下API
      

  3.   

    你去找你的
    开始-程序-MySQL-MySQL Server 5.0-MySQL Server Instance Config Wizard
    直接下一步一下步,改成GBK
      

  4.   

    我只不过没有用过Mysql
    PostgreSQL还是用过的
    那个也差不多
      

  5.   

    我的mysql是4.1.19,为什么我的字符集设置会这么乱呢?
    又有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呢?
      

  6.   

    所那个字段的字符集改成 utf8或GB2312就OK咯~`
      

  7.   

    改字符集为gb2312;
    命令为:alter database db_name default character set gb2312;
      

  8.   

    my.ini中
    default-character-set=gb2312
    就OK了!
      

  9.   

    character_set_client 只要这个是GBK之类就显示输入中文没有问题了....不过前提是表支持中文