Collation problem

How can I set the database can read english, chinese Traditional and chinese
simplified?
ThanksTo store Chinese characters you will need to use appropriate collation (i.e.
Chinese_PRC_Stroke_CS_AS_KS_WS) for the database/table/column plus setting
the datatype for the column to nchar/nvarchar/ntext.
-oj
"Vincent" <aaa@.aaa.com> wrote in message
news:%235vsUTIGFHA.3732@.tk2msftngp13.phx.gbl...
> How can I set the database can read english, chinese Traditional and
> chinese
> simplified?
> Thanks
>|||Vincent,
1. Use Unicode data types (nvarchar(), nchar(), ntext)
2. Use the N prefix for string constants, as in N'_文'
3. Use Unicode-ready fonts in Query Analyzer and other places you enter
and read data (Arial MS Unicode, for example)
Steve Kass
Drew University
Vincent wrote:

>How can I set the database can read english, chinese Traditional and chines
e
>simplified?
>Thanks
>
>|||Which collation name should be chose when creating database?
Thanks
"Steve Kass" <skass@.drew.edu> wrote in message
news:uQmkZ2JGFHA.524@.TK2MSFTNGP14.phx.gbl...
> Vincent,
> 1. Use Unicode data types (nvarchar(), nchar(), ntext)
> 2. Use the N prefix for string constants, as in N''
> 3. Use Unicode-ready fonts in Query Analyzer and other places you enter
> and read data (Arial MS Unicode, for example)
> Steve Kass
> Drew University
> Vincent wrote:
>
chinese|||it's OK now
Thanks a lot
"Steve Kass" <skass@.drew.edu> wrote in message
news:uQmkZ2JGFHA.524@.TK2MSFTNGP14.phx.gbl...
> Vincent,
> 1. Use Unicode data types (nvarchar(), nchar(), ntext)
> 2. Use the N prefix for string constants, as in N''
> 3. Use Unicode-ready fonts in Query Analyzer and other places you enter
> and read data (Arial MS Unicode, for example)
> Steve Kass
> Drew University
> Vincent wrote:
>
chinese