|
edcas
Starting Member
Australia
5 Posts |
 Posted - 08/03/2005 : 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??
|
|
Collation in Column Level
Forum Locked
