mysql中文字符的问题

最新推荐文章于 2024-12-07 22:00:27 发布

DBApower

最新推荐文章于 2024-12-07 22:00:27 发布

阅读量413

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/seeyouc/article/details/53102307

mysql 专栏收录该内容

3 篇文章

订阅专栏

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

2. 更改数据库字符集

3.创建数据库表字符集

4.更改兼容中文的gbk

以下是详细过程

mysql> usemysql

Database changed

mysql> CREATETABLE 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> insertinto table pingfen(zonghepingfen,duanqi)values(6,'你好');

'> ;

'> /

'> ;

'> exit

'> exit;

'>by;

'> Ctrl-C -- exit!

Aborted

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

Welcome to the MySQLmonitor. Commands end with ; or \g.

Your MySQL connection id is4

Server version: 5.1.71 Sourcedistribution

Oracle is a registeredtrademark of Oracle Corporation and/or its

affiliates. Other names may betrademarks of their respective

owners.

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

mysql> usemysql mysql

Database changed

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

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

mysql> select *from pingfen;

------ ---------------------------- --------- ------- ------- -------- -------- ------------------- -------- --------- --------- --------------------------- -----------

------ ---------------------------- --------- ------- ------- -------- -------- ------------------- -------- --------- --------- --------------------------- -----------

------ ---------------------------- --------- ------- ------- -------- -------- ------------------- -------- --------- --------- --------------------------- -----------

1 row in set (0.00sec)

mysql> setnames utf8;

Query OK, 0 rows affected(0.00 sec)

mysql> select *from pingfen;

------ ---------------------------- --------- ------- ------- -------- -------- ------------------- -------- --------- --------- --------------------------- -----------

------ ---------------------------- --------- ------- ------- -------- -------- ------------------- -------- --------- --------- --------------------------- -----------

------ ---------------------------- --------- ------- ------- -------- -------- ------------------- -------- --------- --------- --------------------------- -----------

1 row in set (0.00sec)

mysql> selectduanqi from pingfen;

--------

| duanqi |

--------

| |

--------

1 row in set (0.00sec)

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

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

mysql>commit;

Query OK, 0 rows affected(0.00 sec)