how to design database for chinese and japanese characters

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.

Moving to SQL Server Setup and Upgrade|||

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