Microsoft SQL Server forum - Re: How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data

Author

Re: How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data

micmic.chion@gmail.com

2005-06-27, 3:23 am

I try the method you mentioned in both MS SQL Server in Windows 2000
server and Windows 2K3.

select convert(varbinary, big5col)

It is found that the binary is the same.

I have found out that if you add the following in the heading of the
page,
this page can show the big-5 character.

<%@ codepage=3D950 %>

As the string stored in database is in unicode format, if you set the
codepage as big-5 format, the data will be changed as big-5 and show in
the webpage.

Thank you for your great sugegstion

Ref: Chinese-simpified version:
http://www.evget.com/articles/evget_1092.html

Erland Sommarskog =E5=AF=AB=E9=81=93=E
F=BC=9A
> (micmic.chion@gmail.com) writes:
>
> Hm, if the columns in the database are varchar, then you just cannot
> get Unicode into them. So my guess is that you do have Big-5 in the
> database, and then something happens on the way to the web browser.
>
> You could verify this by looking in Qurey Analyzer and doing a
> SELECT on the table. If it looks OK, then I would guess it is
> Big-5. Do run it even further you could do:
>
> select convert(varbinary, big5col)
>
> and the see whether the codes are Big-5 or Unicode. (This presumes that
> you actually knows the codes for some characters.)
>
> If my theory is correct that the data in the database is Big5, then
> we need to find out why you get Unicode in the browser. Unfortunately,
> I know almost as little about web servers as I know Chinese.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Erland Sommarskog

2005-06-27, 3:23 am

(micmic.chion@gmail.com) writes:
> I try the method you mentioned in both MS SQL Server in Windows 2000
> server and Windows 2K3.
>
> select convert(varbinary, big5col)
>
> It is found that the binary is the same.
>
> I have found out that if you add the following in the heading of the
> page,
> this page can show the big-5 character.
>
><%@ codepage=950 %>
>
>
> As the string stored in database is in unicode format, if you set the
> codepage as big-5 format, the data will be changed as big-5 and show in
> the webpage.
>
>
> Thank you for your great sugegstion

I'm glad to have been to help about something I hardly know at all!

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

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

Sponsored Links