FreeBSD MySQL does not support GBK and solutions

MySQL 5.1, installed with packages, does not support GBK encoding, only supports UTF8 encoding. Specific performance:

When you open a database encoded with GBK, you are prompted

ERROR 1273 (HY000): Unknown collation ' gbk_chinese_ci ' in table ' data_plus ' definition

Set names GBK and set character_set_client = GBK; Hint:

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

Finally have no way, had to use ports recompile.

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 hint, the first three set to be OK.) ）

To view supported encodings:

Show VARIABLES like ' character_set_% ';

Show VARIABLES like ' collation_% ';