MySQL Chinese garbled Problem Solution

After installing MySQL, you are familiar with basic usage, creating databases, and creating tables.

However, when inserting Chinese data into the table, the characters read through C # are garbled, which turns out to be a code problem. MySQL uses Latin encoding by default, while C # uses GBK encoding by default after reading, so that the decoded string is garbled.

To solve this problem, you still need to do it from the database.ArticleTo change the default encoding of the database to GBK, follow these steps:

1. modify my. ini

[Mysqld]

Default-character-set = GBK

[MySQL]

Default-character-set = GBK

2. modify data. Opt in the data folder.

Default-character-set = GBK

Default-collation = gbk_chinese_ci