导航：首页 > 数据库 >

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

发表于：2024-10-15 作者：千家信息网编辑

千家信息网最后更新 2024年10月15日，这篇文章主要介绍mysql中文字符的问题怎么处理，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！mysql中文字符的问题mysql5.1上成功更改的例子：1.在my.cnf中cl

千家信息网最后更新 2024年10月15日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

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;

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

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

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

1 row in set (0.00 sec)

mysql> set names utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> select * from pingfen;

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

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

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

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)