There are SO many character sets in MySQL. I'd like to use a standard
UTF-8 charset, which one do you suggest? Languages that are going to
be written are languages from the entire world, it's to build a
translation system for open-source applications. Thanks.

On Sun, 22 Jul 2007 22:00:38 -0000, Charles <landemaine@gmail.com>
wrote:

>There are SO many character sets in MySQL. I'd like to use a standard
>UTF-8 charset, which one do you suggest? Languages that are going to
>be written are languages from the entire world, it's to build a
>translation system for open-source applications. Thanks.

Utf8-bin, because otherwise you have a case insensitive charset, and
doing a full text search on chinese characters with case insensitive
is not working properly.

On Jul 23, 12:56 am, subtenante <zzsubtenant...@gmail.com> wrote:
> Utf8-bin, because otherwise you have a case insensitive charset, and
> doing a full text search on chinese characters with case insensitive
> is not working properly.

Thanks, ok I'll leave aside utf8_general_ci and utf8_unicode_ci