MYSQL 字符集的设置（命令行模式设置character_set*）

SET character_set_client = gbk ;
SET character_set_connection = gbk ;
SET character_set_database = gbk ;
SET character_set_results = gbk ;
SET character_set_server = gbk ;

SET collation_connection = gbk_bin ;
SET collation_database = gbk_bin ;
SET collation_server = gbk_bin ;

update  props$ set value$ = 'GB2312' where name = 'NLS_CHARACTERSET';  

 

 

 

show   variables   like   "%char%";  
show   variables   like   "%coll%";能看到你的mysql字符集设置，设置都改成big5试试  
  如：  
  SET   character_set_client   =   big5  
  SET   character_set_connection   =   big5  
  SET   character_set_database   =   big5  
  SET   character_set_results   =   big5  
  SET   character_set_server   =   big5  
   
  SET   collation_connection   =   big5  
  SET   collation_database   =   big5  
  SET   collation_server   =   big5