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:
- ucs2 (UCS-2 Unicode) collations:
- utf8 (UTF-8 Unicode) collations:
- big5 (Big5 Traditional Chinese) collations:
- gb2312 (GB2312 Simplified Chinese) collations:
- gbk (GBK Simplified Chinese) collations:
Any help would be much appreciated!!