set up sql server 2000 - Collation settings

[k_sekhar_rao]

hi all,

I need to select collation settings to support chinese characters. As i came to know that i need to select 950 character set. But problem is that i am not able to find the option for chinese characters i.e, 950 character set in the collation settings of the setup. It will be helpful if anyone could suggest me if there is any other option to set while set up or in an existing sql server instance to support chinese character data.

Thanks in advance,
sekhar

[rmiao]

You can set collation at serve, database, table, even column level in sql2k. Besides, check unicode data type.

[olutimi]

Run the query
SELECT *
FROM ::fn_helpcollations()
WHERE Name LIKE 'Chinese%'
to determine available collations.