原来有个结构是
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我如何才能让中文正常显示呢 求指教
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