Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 set up sql server 2000 - Collation settings

Author  Topic 

k_sekhar_rao
Starting Member

8 Posts

Posted - 2003-04-17 : 06:02:55
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

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-04-17 : 06:16:49
Have you tried Alter Database dbname Collate Chinese_PRC_CI_AS ?
Also Check BOL on topic 'SQL Collation Name' for various Collation names

BTW why did you post thrice

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.

Edited by - samsekar on 04/17/2003 06:18:02
Go to Top of Page
   

- Advertisement -