Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Question Unanswered: Question on Collation

    I have some questions about Collation Settings.

    - if my db need to handle traditional chinese, simplified chinese and english, which collation should i use? Is CHINESE_PRC_CI_AS ok?

    - what is meant by 'Anicent Sensitive'?

    - if my db need to handle traditional chinese, simplified chinese english, japanese and korean, then which collation support these languages?

    - How to make the database support unicode? Is is just using nvarchar, ntext, nchar instead of varchar, text and char?


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Unicode allows the use of 16 bit characters. A Unicode string can contain almost any character used on earth, including Roman, Cyrilic, Hebrew, Arabic, Hindu, Chinese, Japanese, Korean, and others. The NCHAR, NTEXT, and NVARCHAR data types support Unicode data.

    No collation that I know of will support traditional chinese without using Unicode.

    I'm pretty sure that you mean "Accent Insensitive", meaning that accents are ignored, so that A, , , and all of their other accented variations are considered to be equivalent.

    I'd store your data in Unicode columns, and only force collation on them when needed for things like sorting and comparison.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts