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  Old Forums  CLOSED - General SQL Server  Collation in Column Level

Author  Topic  edcas Starting Member 5 Posts Posted - 2005-08-03 : 04:52:58 hi, I'm confuse about the collation setting for database level and column level. I have my pc regional setting set to CHINESE PRC, and i have created 2 databases to test the outcome. Database 001 Collation Name set a database level: Chinese_PRC_CI_AS i've created a table as below, and insert a set of chinese character successfully. But this doesn't work in database 002 CREATE TABLE tst_cnchar ( col_1 nvarchar (50), col_2 varchar (50) ) Database 002 Collation Name set a database level: SQL_Latin1_General_CP1_CI_AS (system default) I'm creating the same table again, and enter the chinese character but it won't work. The outcome is in question mark i.e. [???] CREATE TABLE tst_cnchar ( col_1 nvarchar (50) COLLATE Chinese_PRC_CI_AS NULL , col_2 varchar (50) COLLATE Chinese_PRC_CI_AS NULL ) Is there something wrong with my setting??