mysql中文字符的问题怎么处理

这篇文章主要介绍Mysql中文字符的问题怎么处理，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

mysql中文字符的问题
mysql5.1上成功更改的例子：      
      1.在my.cnf中clent和mysqld加入default-character-set=utf8

      2.  更改数据库字符集

      3.创建数据库表字符集

      4.更改兼容中文的gbk

以下是详细过程

mysql> use mysql

Database changed

mysql> CREATE TABLE pingfen

    ->    (CODE VARCHAR(20),

    -> ZONGHEPINGFEN Decimal(12,3),

    -> DATE_INSERT DATEtime,

    -> NEIRONG LONGTEXT,

    -> JISHU Decimal(12,3),

    -> ZIJIN Decimal(12,3),

    -> XIAOXI Decimal(12,3),

    -> HANGYE Decimal(12,3),

    -> JIBEN Decimal(12,3),

    -> PaiXU_TIPS Decimal(12,3),

    -> DUANQI VARCHAR(100),

    -> ZHONGQI VARCHAR(100),

    -> CHANGQI VARCHAR(100),

    -> CHENGBEN Decimal(12,3),

    -> CHENGBENMIAOSHU VARCHAR(500),

    -> WURIZIJIN VARCHAR(100)

    ->    ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

Query OK, 0 rows affected (0.02 sec)

mysql> insert into table pingfen(zonghepingfen,duanqi) values(6,'你好');

    '> ;

    '> ;

    '> /

    '> ;

    '> exit

    '> exit;

    '> by;

    '> Ctrl-C -- exit!

Aborted

[root@master yum.repos.d]# mysql -uroot

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, oracle and/or its affiliates. All rights reserved.

Oracle is a reGIStered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql mysql

Database changed

mysql> insert into  pingfen(zonghepingfen,duanqi) values(6,'你好');

Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> select * from pingfen;

+------+---------------+-------------+---------+-------+-------+--------+--------+-------+------------+--------+---------+---------+----------+-----------------+-----------+

| CODE | ZONGHEPINGFEN | DATE_INSERT | NEIRONG | JISHU | ZIJIN | XIAOXI | HANGYE | JIBEN | PAIXU_TIPS | DUANQI | ZHONGQI | CHANGQI | CHENGBEN | CHENGBENMIAOSHU | WURIZIJIN |

+------+---------------+-------------+---------+-------+-------+--------+--------+-------+------------+--------+---------+---------+----------+-----------------+-----------+

| NULL |         6.000 | NULL        | NULL    |  NULL |  NULL |   NULL |   NULL |  NULL |       NULL |        | NULL    | NULL    |     NULL | NULL            | NULL      |

+------+---------------+-------------+---------+-------+-------+--------+--------+-------+------------+--------+---------+---------+----------+-----------------+-----------+

1 row in set (0.00 sec)

mysql> set names utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> select * from pingfen;

+------+---------------+-------------+---------+-------+-------+--------+--------+-------+------------+--------+---------+---------+----------+-----------------+-----------+

| CODE | ZONGHEPINGFEN | DATE_INSERT | NEIRONG | JISHU | ZIJIN | XIAOXI | HANGYE | JIBEN | PAIXU_TIPS | DUANQI | ZHONGQI | CHANGQI | CHENGBEN | CHENGBENMIAOSHU | WURIZIJIN |

+------+---------------+-------------+---------+-------+-------+--------+--------+-------+------------+--------+---------+---------+----------+-----------------+-----------+

| NULL |         6.000 | NULL        | NULL    |  NULL |  NULL |   NULL |   NULL |  NULL |       NULL |        | NULL    | NULL    |     NULL | NULL            | NULL      |

+------+---------------+-------------+---------+-------+-------+--------+--------+-------+------------+--------+---------+---------+----------+-----------------+-----------+

1 row in set (0.00 sec)

mysql> select duanqi from pingfen;

+--------+

| duanqi |

+--------+

|        |

+--------+

1 row in set (0.00 sec)

mysql> insert into  pingfen(zonghepingfen,duanqi) values(6,'你好111111111111111111');

Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> commit;

Query OK, 0 rows affected (0.00 sec)

mysql> select duanqi from pingfen;

+--------+

| duanqi |

+--------+

|        |

|        |

+--------+

2 rows in set (0.00 sec)

mysql> set names gbk;

Query OK, 0 rows affected (0.00 sec)

mysql> select duanqi from pingfen;

+--------+

| duanqi |

+--------+

|        |

|        |

+--------+

2 rows in set (0.00 sec)

mysql> alter table pingfen character set gbk;    更改兼容中文的gbk

Query OK, 2 rows affected (0.07 sec)

Records: 2  Duplicates: 0  Warnings: 0

mysql> select duanqi from pingfen;

+--------+

| duanqi |

+--------+

|        |

|        |

+--------+

2 rows in set (0.00 sec)

mysql> insert into  pingfen(zonghepingfen,duanqi) values(6,'你好111111111111111111');

Query OK, 1 row affected (0.01 sec)

mysql> select duanqi from pingfen;

+------------------------+

| duanqi                 |

+------------------------+

|                        |

|                        |

| 你好111111111111111111     |

+------------------------+

3 rows in set (0.00 sec)

mysql>

以上是“mysql中文字符的问题怎么处理”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注编程网数据库频道！