cannot display chinese

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HK newsgroup - 29 Jan 2008 19:24 GMT

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as ????.

My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.

I try to fix the problem for several days, but still can't fix it. Please
help me to solve this problem.

here is the detail of my system.
* SQL Server 2005 via TCP/IP
* the connection string is "Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
Source=xx.xx.xx.xx;Password=xx;"

Reply to this Message

Anthony Jones - 01 Feb 2008 18:07 GMT

> I cannot display Chinses at ASP page. All chinese data (whatever is
> Traditional or Simply Chinese) are displayed as ????.
[quoted text clipped - 10 lines]
> Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
> Source=xx.xx.xx.xx;Password=xx;"

Place this at the top of your ASP page and then save using UTF-8 encoding
<%@codepage=65001 %>
<%
Response.CharSet = "UTF-8"
%>

. . . Rest of your page . . .

Signature

Anthony Jones - MVP ASP/ASP.NET

Reply to this Message

Webmaster Forum / ASP / Database Access / February 2008

cannot display chinese