mysql不支持中文
我用的mysql版本是mysql-essential-5.0.87-win32感觉安装和配置都和以前一样,没有问题,但是它不支持中文了,已重装多次,还是没有效果,而且以前是好用的,支持中文的。
databases中的tables:
mysql> show tables;
+----------------+
| Tables_in_htzy |
+----------------+
| message |
| person |
+----------------+
2 rows in set (0.00 sec)
表的属性
mysql> describe person;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| Name | char(20) | NO | PRI | NULL | |
| Paw | char(6) | YES | | NULL | |
| Email | char(30) | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.02 sec)
mysql> describe message;
+-------+-----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-----------+------+-----+---------+-------+
| Name | char(20) | YES | MUL | NULL | |
| Time | char(25) | NO | PRI | NULL | |
| Text | char(140) | YES | | NULL | |
+-------+-----------+------+-----+---------+-------+
3 rows in set (0.01 sec)
查看已有的数据
mysql> select * from person;
+--------+--------+--------------+
| Name | Paw | Email |
+--------+--------+--------------+
| 012345 | 123456 | sd |
| 111 | 222 | 123 |
| 123 | 123456 | 123@123.htzy |
| 456 | 111 | 2355465 |
| htzy | 123456 | sdgfd |
+--------+--------+--------------+
5 rows in set (0.00 sec)
mysql> select * from person;
+---------+--------+--------------+
| Name | Paw | Email |
+---------+--------+--------------+
| 012345 | 123456 | sd |
| 111 | 222 | 123 &