SgDotNet
Singapore Professional .NET User Group -For Cool Developers

Store both traditional and simplified chinese characters

Latest post 03-26-2008 8:09 PM by icelava. 3 replies.
  • 08-12-2007 5:36 PM

    Store both traditional and simplified chinese characters

    Does anybody know what database collation we ought to use in order to accomodate both input of traditional 繁體 繁体 and simplified 简体chinese characters?

    (testing this forums' database) -- ok seems like default collation can take in and retrieve both.

    The melody of logic will always play out the truth. ~ Narumi Ayumu, Spiral

  • 08-13-2007 2:14 AM In reply to

    Re: Store both traditional and simplified chinese characters

    Yup, default collation will do. Just remember to declare nvarchar and use the prefix N as in N'some string value' in direct sql statements. But you might already know this... just for others...
  • 03-26-2008 7:53 PM In reply to

    Re: Store both traditional and simplified chinese characters

    I'm interested in learning this. What is default collation? I would like to learn more. Thanks!
    cheers, YC
  • 03-26-2008 8:09 PM In reply to

    Re: Store both traditional and simplified chinese characters

    icelava:

    (testing this forums' database) -- ok seems like default collation can take in and retrieve both.

    The default collation (SQL_Latin1_General_CP1_CI_AS) is good enough.

    The melody of logic will always play out the truth. ~ Narumi Ayumu, Spiral

Page 1 of 1 (4 items) | RSS
Copyright SgDotNet 2004-2008
Powered by Community Server (Commercial Edition), by Telligent Systems