mysql表里怎么显示中文啊？？

请问mysql建的表里怎么显示中文啊？
谢谢

解决方案 »

  1.   


    如果是在 mysql> 提示符下, 想把中文数据输到表里面的话, 可以试试修改 my.ini 文件, default-character-set=gb2312然后在 mysql> 提示符下mysql> show  variables like 'character%';
    +--------------------------+---------------------------------------------------------+
    | Variable_name            | Value                                                   |
    +--------------------------+---------------------------------------------------------+
    | character_set_client     | gb2312                                                  |
    | character_set_connection | gb2312                                                  |
    | character_set_database   | gb2312                                                  |
    | character_set_filesystem | binary                                                  |
    | character_set_results    | gb2312                                                  |
    | character_set_server     | gb2312                                                  |
    | character_set_system     | utf8                                                    |
    | character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
    +--------------------------+---------------------------------------------------------+