原来有个结构是
CREATE TABLE `members` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET gb2312 COLLATE gb2312_bin NOT NULL,
`password` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=257779 DEFAULT CHARSET=latin1;如题
我现在打开表中文是乱码 我现在用的字符集是UTF8我如何才能让中文正常显示呢 求指教
CREATE TABLE `members` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) CHARACTER SET gb2312 COLLATE gb2312_bin NOT NULL,
`password` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=257779 DEFAULT CHARSET=latin1;如题
我现在打开表中文是乱码 我现在用的字符集是UTF8我如何才能让中文正常显示呢 求指教
解决方案 »
- 用存储过程 拆分字段
- alibaba mysql dba面试题,看看你会不会?
- 特殊编码查询的问题
- mysql 执行 SELECT http_post
- 一篇文章可以属于多个专题,我在文章表里添加一个字段nvarchar(4000) 然后吧文章所属的专题的ID 用豆号分割? 这样写法好不好?
- MySql乱码问题,在线求助!
- 请问mysql中如何将date列的默认值设为当前时间
- mysql 正则 连续数字的判断
- MYSQL order by limit 问题
- ======好消息。。。。。找到绝佳的php+mysql+ftp access搞php的一定得进(Nizvoo)
- repeatable read隔离级别为什么测试下来可以防止幻读?求大神解释!!
- 求将这个MS-SQL语句改成MySql语句
MySQL 中文显示乱码
+--------------------------+---------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | H:\phpStudy2013\MySQL\share\charsets\ |
+--------------------------+---------------------------------------+
select * from tb;
mysql> set names latin1
select * from members;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from members' at line 2