我在Windows vista环境下安装Mysql 5.5版本,用Navicat8 编辑表时显示的中文乱码,而且输入中文后保存不了,显示出错编号为1366。
表的信息如下:
mysql> show create table tb_publishing;
+---------------+--------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------+--------------------------------------------------------------------------------------------------------------------------------------------+
| tb_publishing | CREATE TABLE `tb_publishing` (
`ISBN` varchar(20) DEFAULT NULL,
`pubname` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+---------------+--------------------------------------------------------------------------------------------------------------------------------------------+
1 row in setmysql> show full column
s from tb_publishing;
+---------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| ISBN | varchar(20) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| pubname | varchar(30) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
+---------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
2 rows in set
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 | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set
麻烦各位帮帮忙啊。
表的信息如下:
mysql> show create table tb_publishing;
+---------------+--------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------+--------------------------------------------------------------------------------------------------------------------------------------------+
| tb_publishing | CREATE TABLE `tb_publishing` (
`ISBN` varchar(20) DEFAULT NULL,
`pubname` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+---------------+--------------------------------------------------------------------------------------------------------------------------------------------+
1 row in setmysql> show full column
s from tb_publishing;
+---------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| ISBN | varchar(20) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| pubname | varchar(30) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
+---------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
2 rows in set
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 | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set
麻烦各位帮帮忙啊。
解决方案 »
- 数据完整性约束的问题
- if then else的问题
- 没分了,只求好心人,我在mysql控制台上输错了命令,请问怎么返回mysql>目录啊?
- 一个简单的问题,我想把一段很长的内容存入库中,比如说一封长信的内容,我该把字段设为什么类型合适呢,
- 修改代码的问题,高手帮忙一下,谢先!
- ++++++++请问一个sql查询语句?
- 怪问题,很郁闷,大家看看!
- 探讨:怎样在postgresql中存储类的实例对象?
- 如何解决 "多步 OLE DB 操作产生错误 " 或 "多步操作产生错误。请检查每一步的状态值。"
- 本人刚刚开始学习数据库,可是学的非常迷糊.求推荐数据库设计书籍.
- mysql 存储过程+临时表执行过程中提示临时表不存在
- -- 一个奇怪的My SQL游标循环问题 --
OR
[mysql]default-character-set=utf8
Navicat8 中的 show variables like 'char%'; 是什么?
如果你的表需要支持中文,则建议修改你的表 CREATE TABLE `tb_publishing` (
`ISBN` varchar(20) DEFAULT NULL,
`pubname` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET= utf8
MySQL 中文显示乱码
用UTF8重新创建表后中文内容在网页中显示为“?????”,该如何处理呢