Default mysql encoding _ MySQL

Default mysql encoding problem bitsCN.com
Create database bbs2007; USE bbs2007; create table article (id int primary key AUTO_INCREMENT, pid INT, rootid INT, title VARCHAR (255), cont TEXT, pdate DATETIME, isleaf INT #1-not leaf 0-leaf); INSERT data to the table: insert into article VALUES (NULL, 0, 1, 'Ant vs. elephant ', 'Ant vs. elephant', NOW (), 1); ERROR 1406 (22001) when MySQL is inserted into Chinese ): data too long for column 'name' at row 1
Solution:
Run the set names gbk command before executing the SQL statement for data insertion. The reason is that the default encoding of MySQL Client is Latin1, which does not support Chinese characters. set names gbk. All fields are encoded in Chinese. From heirenheiren's column bitsCN.com