iEntry 10th Anniversary Forum Rules Search
WebProWorld
Register FAQ Calendar Mark Forums Read
Web Programming Discussion Forum Working with an API? Developing a plugin? Writing a Mod or script for your favorite blog, Web 2.0 site or Forum? Welcome.

Share Thread: & Tags

Share Thread:

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-09-2006, 12:23 AM
EJRS.COM's Avatar
WebProWorld Veteran
 
Join Date: Dec 2003
Location: Malaysia
Posts: 680
EJRS.COM RepRank 0
Default Chinese Text UTF 8

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!!

Thanks
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Web Programming Discussion Forum

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 12:57 AM.



Search Engine Optimization by vBSEO 3.3.0