1.安装mysql中选择数据字符集为utf-8

2.创建数据库

create database zhaochao charset utf8;
  • 1.



3.创建表时 

create table user(id int ,username varchar(60),userpasswd varchar(60)) charset utf8;
  • 1.



4.插入数据时 

set names gbk;
  • 1.



mysql中文乱码解决_MySQL

C:\Users\Administrator>mysql -uroot -padmin
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database zhaochao charset utf8;
Query OK, 1 row affected (0.00 sec)

mysql> use zhaochao;
Database changed
mysql> create table user(id int ,username varchar(60),userpasswd varchar(60)) charset utf8;
Query OK, 0 rows affected (0.07 sec)

mysql> show variables like '%char%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | utf8                                                    |
| character_set_connection | utf8                                                    |
| character_set_database   | utf8                                                    |
| character_set_filesystem | binary                                                  |
| character_set_results    | utf8                                                    |
| character_set_server     | utf8                                                    |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

mysql> insert into user values (1,'赵超','zhaochao');
ERROR 1406 (22001): Data too long for column 'username' at row 1
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into user values (1,'赵超','zhaochao');
Query OK, 1 row affected (0.02 sec)

mysql> select * from user;
+------+----------+------------+
| id   | username | userpasswd |
+------+----------+------------+
|    1 | 赵超        | zhaochao   |
+------+----------+------------+
1 row in set (0.00 sec)

mysql> select * from user;
+------+----------+------------+
| id   | username | userpasswd |
+------+----------+------------+
|    1 | 赵超        | zhaochao   |
|    1 | 赵云         | zhaoyun    |
+------+----------+------------+
2 rows in set (0.00 sec)

mysql> select * from user;
+------+----------+------------+
| id   | username | userpasswd |
+------+----------+------------+
|    1 | 赵超        | zhaochao   |
|    1 | 赵云         | zhaoyun    |
|    1 | 赵云         | zhaoyun    |
+------+----------+------------+
3 rows in set (0.00 sec)
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.
  • 18.
  • 19.
  • 20.
  • 21.
  • 22.
  • 23.
  • 24.
  • 25.
  • 26.
  • 27.
  • 28.
  • 29.
  • 30.
  • 31.
  • 32.
  • 33.
  • 34.
  • 35.
  • 36.
  • 37.
  • 38.
  • 39.
  • 40.
  • 41.
  • 42.
  • 43.
  • 44.
  • 45.
  • 46.
  • 47.
  • 48.
  • 49.
  • 50.
  • 51.
  • 52.
  • 53.
  • 54.
  • 55.
  • 56.
  • 57.
  • 58.
  • 59.
  • 60.
  • 61.
  • 62.