locked
how to design database for chinese and japanese characters RRS feed

  • Question

  • I need a small confirmation regarding storing the Chinese and Japanese characters in sql server. Can we store Chinese and Japanese characters on a same database with Chinese Collation? Or else we need to store it separately with respective collations.

    I tried to store both characters on db with Chinese collation it works but I am not so sure if it is right way to do so. Please confirm on this as we are doing research stage to build website  in Chinese and japanese.

    Thanks in advance.

    Thursday, August 23, 2007 11:07 AM

Answers

  •  vrkanaka wrote:

    I need a small confirmation regarding storing the Chinese and Japanese characters in sql server. Can we store Chinese and Japanese characters on a same database with Chinese Collation? Or else we need to store it separately with respective collations.

    I tried to store both characters on db with Chinese collation it works but I am not so sure if it is right way to do so. Please confirm on this as we are doing research stage to build website  in Chinese and japanese.

    Thanks in advance.

     

    The Chinese and Japanese alphabets are more than 2000 characters so you need to find the version of Chinese and Japanese and use the correct code page and collations for each language with NVarchar or NVarchar(max).  Hope this helps.

    http://msdn2.microsoft.com/en-us/library/ms144250.aspx


    http://msdn2.microsoft.com/en-us/library/ms180175.aspx

     

    Thursday, August 23, 2007 5:56 PM

All replies

  • Moving to SQL Server Setup and Upgrade

     

    Thursday, August 23, 2007 11:34 AM
  •  vrkanaka wrote:

    I need a small confirmation regarding storing the Chinese and Japanese characters in sql server. Can we store Chinese and Japanese characters on a same database with Chinese Collation? Or else we need to store it separately with respective collations.

    I tried to store both characters on db with Chinese collation it works but I am not so sure if it is right way to do so. Please confirm on this as we are doing research stage to build website  in Chinese and japanese.

    Thanks in advance.

     

    The Chinese and Japanese alphabets are more than 2000 characters so you need to find the version of Chinese and Japanese and use the correct code page and collations for each language with NVarchar or NVarchar(max).  Hope this helps.

    http://msdn2.microsoft.com/en-us/library/ms144250.aspx


    http://msdn2.microsoft.com/en-us/library/ms180175.aspx

     

    Thursday, August 23, 2007 5:56 PM