aimds
asked on
SQL 2005 collation
collation database is SQL_Latin1_General_CP1_CI_ AS
I created table for suport Chinese like below
how do set the column for support ?
I created table for suport Chinese like below
how do set the column for support ?
CREATE TABLE [dbo].[DESC] (
[ITEM_CODE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DESCRIPTION] [nvarchar](200) COLLATE Chinese_PRC_CS_AI NULL ,
[ITEM_DETAIL] [nvarchar] (1000) COLLATE Chinese_PRC_CS_AI NULL
) ON [PRIMARY]
GO
Insert DESC (ITEM_CODE,DESCRIPTION)
Values('xxx','}±^' COLLATE Chinese_PRC_CS_AI )
select description COLLATE Chinese_PRC_CS_AI as description from DESC
the column description it becase like this "?????"
that code is working perfeclty on my system
ASKER
My collation database is SQL_Latin1_General_CP1_CI_ AS
the collation of the database dosn't matter when you specify the column collation, can you test it on a different database, possibly tempdb ?
ASKER
I tried new database and set collation SQL_Latin1_General_CP1_CI_ AS and then created table
CREATE TABLE [dbo].[DESC] (
[ITEM_CODE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL ,
[DESCRIPTION] NVARCHAR(200) COLLATE Chinese_PRC_CS_AI NULL ,
[ITEM_DETAIL] [nvarchar] (1000) COLLATE Chinese_PRC_CS_AI NULL
) ON [PRIMARY]
GO
Insert [DESC] (ITEM_CODE,DESCRIPTION)
Values('xxx','}±^örÅ£t" KëP' COLLATE Chinese_PRC_CS_AI )
select * from [DESC]
it's the same old problem
xxx ??????????"???? NULL
then I tried new database and set collation was Chinese_PRC_CS_AI
and created table with the same script above it's ok
CREATE TABLE [dbo].[DESC] (
[ITEM_CODE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_
[DESCRIPTION] NVARCHAR(200) COLLATE Chinese_PRC_CS_AI NULL ,
[ITEM_DETAIL] [nvarchar] (1000) COLLATE Chinese_PRC_CS_AI NULL
) ON [PRIMARY]
GO
Insert [DESC] (ITEM_CODE,DESCRIPTION)
Values('xxx','}±^örÅ£t"
select * from [DESC]
it's the same old problem
xxx ??????????"???? NULL
then I tried new database and set collation was Chinese_PRC_CS_AI
and created table with the same script above it's ok
ASKER
how do i create new table for support Chinese ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much