MySQL cannot insert Chinese characters.

Switch from csdn -- http://topic.csdn.net/u/20070418/16/b7ad36d1-d011-45a4-b4e5-d796d65feedd.html

 

MySQL sets the encoding method

MySQL can insert English fields into the database. When I enter Chinese characters, the field data truncation: data too long for column 'name' at Row 1 appears.
My friend's method is as follows:

(1) Modify c: \ developer \ mysql5.0 \ My. ini (MySQL server instance configuration file)
Set default-character-set = GBK (Note: there are 2 places)
(2) modify the DB. Opt configuration file under the corresponding database directory in the Data Directory
Default-character-set = GBK
Default-collation = gbk_chinese_ci
Restart MySQL.
But the problem persists!
Is there any other way for friends?
Of course, if my name varchar (40) can contain 20 Chinese characters, I only need to query 2 Characters!