After finding a long time, I finally found the post to solve my mysql's Chinese problem. However, the answer is still very chaotic, but I am willing to open source, if there is no open source, and like the kind of pirated disc, it is hard to imagine How will the software will become a nonsense, or a nonsense?
Solve MySQL Chinese Problem First, add such information in MySQL profile mysql.ini:
[Winmysqladmin] server = c: /mysql/bin/mysqld-nt.exequeryinterval=10 [mysqld] basedir = c: / mysql datadir = c: / mysql / data default-character-set = GBK [client] default-character-character-character- SET = GBK
This is to ensure that mysql displays the problem, but the external data insert is not a formal Chinese, but also add the character set when the key table is gbk, I give you the example of my own key table, please refer to you:
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 This Chinese problem is solved, the inserted data is also turned into Chinese, huh, huh :)
Simple. Help, but you can pull it directly to write in Chinese, you can pull it, don't turn it, then you can also take the data out to see if you do it wrong, should be Chinese.
Xie Peineng in the creation of my technology 05-4-25
