Posted by Erland Sommarskog on 06/27/05 10:33

(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/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Replication Problem!
• Prev in forum: Re: Re: connectionopen (SeCDoClientHandshake().]SSL Security err
• Thread view: Re: How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data

[Reply to this message]