MySQL5.5.28 character set setting_mysql

Settings of the mysql5.28 character set bitsCN.com

MySQL 5.5.28 character set settings

The Chinese characters of the inserted database are garbled. use default-character-set = gbk under mysqld. mysql services cannot be started.

See relevant chapters in the official documentation

Http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_character_set_client

The following result is displayed, the client settings remain unchanged, and the settings under mysqld are changed to the following.

[Client]

Default-character-set = gbk

[Mysqld]

Character_set_server = gbk

Character_set_server = gbk // affects Server characterset and Db characterset, corresponding to 1 and 2

Default-character-set = gbk // affects Client characterset and Conn characterset corresponding to 3 and 4

BitsCN.com