cannot display chinese with ASP and SQL Server
  Home FAQ Contact Sign in
microsoft.public.arabic.sqlserver only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver Profile…
 Up
cannot display chinese with ASP and SQL Server         


Author: HK newsgroup
Date: Jan 29, 2008 11:24

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;"
2 Comments
Re: cannot display chinese with ASP and SQL Server         


Author: Aqeel
Date: Apr 21, 2008 12:55

hi
I think that you have to install chinese language to your computer
I hope I benfit you
your brother in god aqeel
"HK newsgroup" websonic.com.hk> wrote in message
news:Oc6vvxqYIHA.5416@TK2MSFTNGP05.phx.gbl...
>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;" ...
Show full article (0.79Kb)
no comments
RE: cannot display chinese with ASP and SQL Server         


Author: Ekrem Önsoy
Date: May 14, 2008 10:43

Hello

You should ensure that you use the correct Code Page in your web.config file.

And then you should ensure that your data in your SQL Server database is
correct

and shows Chineese characters in the right way. After ensuring this, you can
assume that you use an incorrect Code Page in your web configuration file !

This problem occurs usually because of the wrong code page setting.

Ekrem Önsoy

"HK newsgroup" wrote:
Show full article (1.02Kb)
no comments

RELATED THREADS
SubjectArticles qty Group
Re: Comando do DOS no SQL Server ?!microsoft.public.br.sqlserver ·
Re: I Cannot install SQL Server 2005 Enterprise on Vista !!microsoft.public.sqlserver.setup ·
SQL Server 2005 32 bit and Sharepoint 32 bit on 64 bit OS?microsoft.public.sharepoint.setup_and_administration ·