At first, I thought it was my own character length problem, and after shortening it was still a problem. The original is because the Chinese code.
Workaround: Modify the DEFAULT_CHARACTER_SET=GBK in the My.ini file;
# CLIENT section#----------------------------------------------------------------------# # The following options would be read by MySQL client applications.# Note This only client applications shipped by MyS QL is guaranteed# to read ThisSection . If you want your own MySQL client program to# Honor these values, you need to specify it as an option during the# MySQL CL Ient Library Initialization.#[client]port=3306[MySQL]default-character-set=gbk# SERVER section#----------------------------------------------------------------------# # The following options would be read by the MySQL Server. Make sure that# you had installed the server correctly (see above) so it reads This# file.#[mysqld]# The TCP/IP Port The MySQL Server would listen Onport=3306#Path to installation directory. All paths is usually resolved relative to This. Basedir= "C:/Program files/mysql/mysql Server 5.0/"#Path to the database Rootdatadir= "C:/Program files/mysql/mysql Server 5.0/data/"# thedefaultCharacter set that would be used when aNewschema or table is# created and no character set is defineddefault-character-set=utf8
MySQL add Chinese, Data too long for column error