Search the MySQL manual:

4.6.6 Multi-byte Character Support

If your want to add support for a new character set that includes multi-byte characters, you need to use the multi-byte character functions.

Right now the best documentation on this is the character sets that are already implemented. Look at the euc_kr, gb2312, gbk, sjis, and ujis character sets for examples. These are implemented in the `ctype-'charset'.c' files in the `strings' directory.

You must specify the mbmaxlen_MYSET=N value in the special comment at the top of the source file. N should be set to the size in bytes of the largest character in the set.

User Comments

Posted by Alexander Voropay on Tuesday January 21 2003, @8:18am[Delete] [Edit]

It seems, it is possible to create sorting for UTF-8 charset with mbmaxlen_MYSET=6 ...

Posted by Stone Chen on Thursday June 12 2003, @7:05pm[Delete] [Edit]

Now I need to configure MySQL on my Windows server to support GBK and Big5. The MySQL manual suggests ./configure --with-charset=charset however, this method is Linux only and won't work for me. Could someone tell me how this could be done? P.S. I took a look under the /share directory, and there is no chinese, no gb2312, gbk, nor big5 sub-directories. The manual should have something on how to configure Windows servers to work with MySQL on this.

Add your own comment.