The Chinese text is being stored in the database as UTF-8 characters. The question is what collation should I use to determine how the text gets sorted when retrieved from the database?

Here are the collations that are available to me:

UTF8

1. ucs2 (UCS-2 Unicode) collations:

ucs2_bin

ucs2_general_ci (default)

ucs2_general_uca


2. utf8 (UTF-8 Unicode) collations:

utf8_bin

utf8_general_ci (default)


3. big5 (Big5 Traditional Chinese) collations:

big5_bin

big5_chinese_ci (default)


4. gb2312 (GB2312 Simplified Chinese) collations:

gb2312_bin

gb2312_chinese_ci (default)


5. gbk (GBK Simplified Chinese) collations:

gbk_bin

gbk_chinese_ci (default)

Any help would be much appreciated!!