Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How NVarchar data display in ASP Page

Author  Topic 

Sammar
Starting Member

3 Posts

Posted - 2002-04-16 : 08:05:09
I have a database in SQL server and some of the fields of tables are of NVarchar dayatype i want to display them in ASP page but when i write them on ASP page the result in the form of ?????. I want the solution how to get appropriate/actual output at ASP Page.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-16 : 08:26:11
This probably requires setting the Response.Charset option to a unicode character set. I don't know exactly what character set should be used, but if you check these ASP sites:

www.4guysfromrolla.com
www.15seconds.com
www.asp101.com
www.aspalliance.com

One of them is bound to have it. Also search http://msdn.microsoft.com for "ASP character sets" and you'll probably find a list of them.

Go to Top of Page

joldham
Wiseass Yak Posting Master

300 Posts

Posted - 2002-04-16 : 13:07:15
I believe you can use UTF-8 if you have mixed encoding types on one page (English and Russian, etc.) If you are dealing with a single language on a page (Russian Only), use the encoding type for that page (Cyrillic-Koi). Check robvolk's links above for the appropriate type for individual languages.

Jeremy

Go to Top of Page
   

- Advertisement -