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

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

2. 更改数据库字符集

3.创建数据库表字符集

4.更改兼容中文的gbk

以下是详细过程

mysql>use mysql

Databasechanged

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@masteryum.repos.d]# mysql -uroot

Welcometo the MySQL monitor. Commands end with; or \g.

YourMySQL connection id is 4

Serverversion: 5.1.71 Source distribution

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

Oracle isa 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

Databasechanged

mysql>insert intopingfen(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 inset (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 inset (0.00 sec)

mysql>select duanqi from pingfen;

+--------+

| duanqi|

+--------+

| |

+--------+

1 row inset (0.00 sec)

mysql>insert intopingfen(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 inset (0.00 sec)

mysql>set names gbk;

Query OK,0 rows affected (0.00 sec)

mysql>select duanqi from pingfen;

+--------+

| duanqi|

+--------+

| |

| |

+--------+

2 rows inset (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 inset (0.00 sec)

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

Query OK,1 row affected (0.01 sec)

mysql>select duanqi from pingfen;

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

|duanqi |

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

| |

| |

| 你好111111111111111111 |

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

3 rows inset (0.00 sec)

mysql>

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