SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Collation in Column Level
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

edcas
Starting Member

Australia
5 Posts

Posted - 08/03/2005 :  04:52:58  Show Profile
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??

  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000