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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How NVarchar data display in ASP Page
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sammar
Starting Member

Pakistan
3 Posts

Posted - 04/16/2002 :  08:05:09  Show Profile  Reply with Quote
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

USA
15732 Posts

Posted - 04/16/2002 :  08:26:11  Show Profile  Visit robvolk's Homepage  Reply with Quote
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

USA
300 Posts

Posted - 04/16/2002 :  13:07:15  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000