mysql中文字符的問題怎么處理

這篇文章主要介紹MySQL中文字符的問題怎么處理，文中介紹的非常詳細(xì)，具有一定的參考價值，感興趣的小伙伴們一定要看完！

成都創(chuàng)新互聯(lián)專注于清河網(wǎng)站建設(shè)服務(wù)及定制，我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗。熱誠為您提供清河營銷型網(wǎng)站建設(shè)，清河網(wǎng)站制作、清河網(wǎng)頁設(shè)計、清河網(wǎng)站官網(wǎng)定制、微信小程序服務(wù)，打造清河網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供清河網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。

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

2. 更改數(shù)據(jù)庫字符集

3.創(chuàng)建數(shù)據(jù)庫表字符集

4.更改兼容中文的gbk

以下是詳細(xì)過程

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)

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中文字符的問題怎么處理”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對大家有幫助，更多相關(guān)知識，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

分享標(biāo)題：mysql中文字符的問題怎么處理
本文URL：http://www.muchs.cn/article28/jsoojp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供微信公眾號、App設(shè)計、App開發(fā)、服務(wù)器托管、網(wǎng)站制作、標(biāo)簽優(yōu)化

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容