MySQL如何显示中文,存储中文

来源：互联网发布：swift game 源码编辑：程序博客网时间：2024/06/02 04:26

看着不爽
mysql> select * from goods;
+-------+----------------------+-------+------+-----------+-----------+
| ID    | NAME                 | Price | CNT | trademark | TYPE      |
+-------+----------------------+-------+------+-----------+-----------+
| 10000 | iPhone7              | 8000 | 600 | Apple     | 鎵嬫満      |
| 51091 | MacBook Air MD 224   | 8799 |   30 | Apple     | 绗旇鏈?   |
| 51092 | Galaxy Note II N7100 | 5199 | 100 | Samsung   | 鎵嬫満      |
| 51093 | MV800                | 1499 |    5 | Samsung   | 鐩告満      |
| 51094 | K860 鍥涙牳 3G         | 2188 | 300 | Lenovo    | 鎵嬫満      |
| 51095 | S7562 3G             | 1798 | 200 | Samsung   | 鎵嬫満      |
| 51096 | Y470P-IFI            | 4299 | 200 | Lenovo    | 绗旇鏈?   |
| 51097 | NP-E3415-J01CN       | 3300 | 150 | Samsung   | 绗旇鏈?   |
| 51098 | iPhone 4S 64G        | 4799 | 220 | Apple     | 鎵嬫満      |
| 51099 | iPhone 6             | 7000 |   50 | Apple     | 鎵嬫満      |
+-------+----------------------+-------+------+-----------+-----------+
10 rows in set (0.00 sec)
查看当前使用的字符集
show variables like '%character%';
显示的：
+--------------------------+---------------------------------------------------
-----------+
| Variable_name            | Value
           |
+--------------------------+---------------------------------------------------
-----------+
| character_set_client     | utf8
           |
| character_set_connection | utf8
           |
| character_set_database   | utf8
           |
| character_set_results    | utf8
           |
| character_set_server     | utf8
           |
| character_set_system     | utf8
           |
| character_sets_dir       | C:\Program Files (x86)\MySQL\MySQL Server 5.0\shar
\charsets\ |
+--------------------------+---------------------------------------------------
-----------+
7 rows in set (0.00 sec)
设置能显示中文，存储中文
set character_set_client=gbk;
set character_set_results=gbk;
显示如下：
mysql> set character_set_client=gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results=gbk;
Query OK, 0 rows affected (0.09 sec)
show variables like '%character%';查看一下
+--------------------------+----------------------------------------------------
-----------+
| Variable_name            | Value
           |
+--------------------------+----------------------------------------------------
-----------+
| character_set_client     | gbk
           |
| character_set_connection | utf8
           |
| character_set_database   | utf8
           |
| character_set_results    | gbk
           |
| character_set_server     | utf8
           |
| character_set_system     | utf8
           |
| character_sets_dir       | C:\Program Files (x86)\MySQL\MySQL Server 5.0\share
\charsets\ |
+--------------------------+----------------------------------------------------
示例
mysql> use test2;
Database changed
mysql> select * from goods;
+-------+----------------------+-------+------+-----------+--------+
| ID    | NAME                 | Price | CNT | trademark | TYPE   |
+-------+----------------------+-------+------+-----------+--------+
| 10000 | iPhone7              | 8000 | 600 | Apple     | 手机      |
| 51091 | MacBook Air MD 224   | 8799 |   30 | Apple     | 笔记本     |
| 51092 | Galaxy Note II N7100 | 5199 | 100 | Samsung   | 手机      |
| 51093 | MV800                | 1499 |    5 | Samsung   | 相机       |
| 51094 | K860 四核 3G            | 2188 | 300 | Lenovo    | 手机      |
| 51095 | S7562 3G             | 1798 | 200 | Samsung   | 手机      |
| 51096 | Y470P-IFI            | 4299 | 200 | Lenovo    | 笔记本     |
| 51097 | NP-E3415-J01CN       | 3300 | 150 | Samsung   | 笔记本     |
| 51098 | iPhone 4S 64G        | 4799 | 220 | Apple     | 手机      |
| 51099 | iPhone 6             | 7000 |   50 | Apple     | 手机      |
+-------+----------------------+-------+------+-----------+--------+
10 rows in set (0.08 sec)
字符集的事改成国标码gbk完成

0 0