Posted by Erland Sommarskog on 06/10/05 00:21

(micmic.chion@gmail.com) writes:
> I am using Windows 2003 Server English Version. I wanna store the big-5
> data so I install the sql server 2000 as if i install it in the Windows
> 2000 with Server Collation of the Chinese_Taiwan_Stroke_CL_AS.
> However, the data are stored into the database server in unicode
> instead of big-5 in that of windows 2000 OS.
>
> I would like to ask how i can set so that the Sql Server 2000 can store
> the big-5 data

First of all, my knowledge and experience of Chinese and its character
sets is very limited, so bear with me.

I was under the impression that for non-Unicode characters sets, East
Asian languages are stored in varchar as double-byte character sets.
Unicode is stored in nvarchar. So you would probably use varchar for
your data. Could this be the answer?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: SQL2K WIN2K3 CONNECTION SECURITY
• Prev in forum: Re: SQL server job timeouts?
• Thread view: Re: How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data

[Reply to this message]