Unable to insert Chinese when using MySQL.

Use the tools, MySql5.0 and graphical tools Navacat.
1. Change the configuration in the My.ini in the MySQL system file first as soon as you install it.

 
   
  

  
    
   
[mysql]
  
    
   

  
    
   
default-character-set=gbk #默认是latin1，把他改成了gbk。
 
   
  

2. The table is then created, but when the Chinese value is inserted, "Data too long for column ' Realname ' at row 1" is displayed. No matter how long the varchar is changed. after the Internet to find the answer, because I use the graphics, most of the Internet is the command line, so ultimately no fruit.
3. Later Daoteng himself Navacat. A. First, the MySQL configuration file My.ini is opened. [Mysqld] was found.


B. change the configuration below.

  
 

   
  

  
# The default character set that will be used when a new schema or table is
   
  

  
# created and no character set is defined
   
  

  
default-character-set=utf8 #默认是latin1, changed him into a utf8.
  
 

c. Open the database table with Navacat, right-click Table, select Design Table

d. Select the column you want to modify, and then there is a "character set" option below. (Haha, now clear), change the character set on it!!

4. Then I inserted in the Chinese will be no problem!!









From for notes (Wiz)

Unable to insert Chinese when using MySQL.