mysql 接收中文字符_mysql中文字符的问题全面处理-CSDN博客

本文链接：https://blog.csdn.net/weixin_34110970/article/details/113904562

这篇博客详细介绍了在MySQL 5.1版本上处理中文字符问题的步骤，包括修改my.cnf配置文件设置默认字符集为UTF8，创建数据库和表时指定字符集，以及如何从UTF8转换到GBK以兼容中文。文中通过创建表格并插入包含中文的数据，展示了字符集设置的正确性和转换过程。

摘要由CSDN通过智能技术生成

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

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 |

WURIZIJIN |

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

| NULL

| 6.000 | 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 |

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

| NULL

| 6.000 | 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>