Collation - Chinese Characters with English

[gc6294]

I have a SQL Server 2000 database. My company does a lot of business with Chinese vendors and customers. I would like to have some of my forms print out in Chinese in addition to English with the rest of the database basically in English. I was thinking of adding some cross-reference tables for say part number description and vendor and customer addresses in Chinese so I could print my forms off of these fields and keep the original tables in English. Anyone ever have any experience doing something like this? I'm told there may be collation issues?

 

[Crowley16]

collation specifies the ordering of the "alphabet"

if you're going to be using a standard collation for your database, and using both english and chinese characters, then when you're ordering or comparing the results, you might get strange results, however if you're going to be english as the main alphabet throughout, with only brief references to chinese, then it should be ok.

p.s. if you're going to be using international charsets, then make sure in EVERY field you're using nVarchar or nChar

--------------------
Procrastinate Now!