MySQL does not support GBK encoding.

In Linux, MySQL5.1 installed with packages does not support GBK encoding. It only supports UTF8 encoding. Specific performance: the error "ERROR1273" is displayed when a database encoded with GBK is opened.

In Linux, MySQL5.1 installed with packages does not support GBK encoding. It only supports UTF8 encoding. Specific performance: When opening a database encoded with GBK, the ERROR 1273 is displayed.

In Linux, MySQL5.1 installed with packages does not support GBK encoding. It only supports UTF8 encoding. Specific performance:

When you open a database encoded with GBK, the following message is displayed:

ERROR 1273 (HY000): Unknown collation 'gbk _ chinese_ci 'in table 'data _ plus' definition

Set names gbk; and SET character_set_client = gbk; prompt:

ERROR 1115 (42000): Unknown character set: 'gbk'

Finally, I had to use ports to re-compile.

Cd/usr/ports/databases/mysql51-server

Make WITH_CHARSET = gbk WITH_XCHARSET = all WITH_COLLATION = gbk_chinese_ci BUILD_STATIC = yes install clean

(In fact, when make install clean, there is a parameter prompt, you can set the first three .)

View supported codes:

Show variables like 'character _ set _ % ';

Show variables like 'collation _ % ';