mysql中文乱码问题

找了好久的资料,终于找到了解决mysql的中文问题的贴子,不过一般的帖子回答还是挺乱的，不过还是多谢开源啊，如果没有开源,而像那种打击盗版光碟那样,很难想象软件业会成为怎样呢，废话少说，还是言归正传把.

解决mysql中文问题首先要在mysql的配置文件mysql.ini里面添加这么一段信息:

[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
QueryInterval=10
[mysqld]
   basedir=c:/mysql
   datadir=c:/mysql/data
   default-character-set=gbk
  
[client]
   default-character-set=gbk

这样的做法是确保mysql显示问题,不过在外面的数据插入不是正式的中文话，还要在键表的时候加上字符集是gbk,我给出我自己键表的例子给你们参考一下:

CREATE TABLE `characters` (                                                                                                                                                                                                                                                                                                                                                                  
              `id` int(11) NOT NULL default '0',                                                                                                                                                                                                                                                                                                                                                         
              `author` varchar(20) default NULL,                                                                                                                                                                                                                                                                                                                                                         
              `publisher` varchar(50) default NULL,                                                                                                                                                                                                                                                                                                                                                      
              `date` datetime default NULL,                                                                                                                                                                                                                                                                                                                                                              
              `title` varchar(250) NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                  
              `content` text,                                                                                                                                                                                                                                                                                                                                                                            
              `reply` int(11) default '0',                                                                                                                                                                                                                                                                                                                                                               
              `flag` int(11) NOT NULL default '0',                                                                                                                                                                                                                                                                                                                                                       
              PRIMARY KEY  (`id`)                                                                                                                                                                                                                                                                                                                                                                        
            ) ENGINE=InnoDB DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC                                                                                                                                                                                                                                                                                                                                       

这样中文问题就解决拉，插入的数据也变成中文了，呵呵:)

简单把.好拉，不过插入的时候你直接写插入中文就可以拉，不用转什么码,接着你也可以丛中把数据拿出来看看，如果操作没错的话应该也是中文才对.

                                                                                                                谢培能               于创我科技     05-4-25