mysql 不能插入中文记录

问题:

# ERR: Incorrect string value: '\xE5\xAD\x9F\xE5\xBB\xBA...' for column 'chinese_name' at row 1 (MySQL error code: 1366, SQLState: HY000 )

 

解决方法:

alter table table_name convert to character set utf8;



参考:
http://www.cnblogs.com/livingintruth/p/3433259.html

posted on 2017-10-12 17:50  兔子二  阅读(123)  评论(0编辑  收藏  举报

导航