在MYSQL QUERY BROWSER中执行语句insert into sc_name value (9,5,'天空')
Incorrect string value: '\xE5\xA4\xA9\xE7\xA9\xBA' for column 'info' at row 1我搜索了一下关于乱码的问题,按照提示
我已经使用
mysql> SET character_set_client = utf8 ;
mysql> SET character_set_connection = utf8 ;
mysql> SET character_set_database = utf8 ;
mysql> SET character_set_results = utf8 ;
mysql> SET character_set_server = utf8 ;设置好了字符集在设置COLLATION时
mysql> SET collation_connection = utf8 ;
mysql> SET collation_database = utf8 ;
mysql> SET collation_server = utf8 ;出现ERROR 1273 (HY000): Unknown collation: 'utf8'
Incorrect string value: '\xE5\xA4\xA9\xE7\xA9\xBA' for column 'info' at row 1我搜索了一下关于乱码的问题,按照提示
我已经使用
mysql> SET character_set_client = utf8 ;
mysql> SET character_set_connection = utf8 ;
mysql> SET character_set_database = utf8 ;
mysql> SET character_set_results = utf8 ;
mysql> SET character_set_server = utf8 ;设置好了字符集在设置COLLATION时
mysql> SET collation_connection = utf8 ;
mysql> SET collation_database = utf8 ;
mysql> SET collation_server = utf8 ;出现ERROR 1273 (HY000): Unknown collation: 'utf8'
my.ini
[mysql]
default-character-set= utf8
[mysqld]
default-character-set= utf8
重启MYSQL。 在数据库里执行语句:alter database charset = utf8; 你的数据录入时先执行set names utf8;改表中要输入中文字段的CHARACTER SET,命令好像是ALTER TABLE `t1` CHANGE `ee` `ee` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 中间那部分。
set names 'utf-8';
再插入试试
我遇到过这种问题,字符集需要设置为"GBK"请看我以前发的一个帖子 :
http://topic.csdn.net/u/20080420/16/62203c88-a124-4bff-8b27-1c1cee68b9dc.html