Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > ADO recordset returns UTF8 instead ISO-8859-1

Reply
Thread Tools

ADO recordset returns UTF8 instead ISO-8859-1

 
 
Frakes
Guest
Posts: n/a
 
      04-04-2007
I'm using ADO to read an access database using ASP.

My problem is, that i get e.g. ü instead of

Does anyone know y?

I am using following doctype:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/
TR/xhtml11/DTD/xhtml11.dtd">

I am using following contenttype:
<meta http-equiv="content-type" content="text/html;
charset=iso-8859-1">

 
Reply With Quote
 
 
 
 
Anthony Jones
Guest
Posts: n/a
 
      04-05-2007
>>>>>>
"Frakes" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) ups.com...
I'm using ADO to read an access database using ASP.

My problem is, that i get e.g. ü instead of

Does anyone know y?

I am using following doctype:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/
TR/xhtml11/DTD/xhtml11.dtd">

I am using following contenttype:
<meta http-equiv="content-type" content="text/html;
charset=iso-8859-1">
<<<<<<

It might help if you showed us the code you use to retrieve the value from
the DB and forward to the client.

Here are a couple of potential scenarios.

1.) The response codepage is set to 65001 but your meta tag says its
iso-8859-1. The sort of corruption you are seeing is exactly what I'd
expect to see. (BTW, the http-equic is real ugly. Use Response.ContentType
and Response.CharSet that modifiy the header properly).


2.) The field actually does contain ü instead of , use an independant tool
like Access itself to take a look.

Finally why use ISO-8859-1? If you going to the trouble of using xhtml you
might as well go with UTF-8 as well.



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
given char* utf8, how to read unicode line by line, and output utf8 gry C++ 2 03-13-2012 04:32 AM
Accessing an ADO Recordset or Record from ADO.NET nita ASP .Net 1 11-20-2004 07:06 AM
Load XML from ADO Recordset Mac ASP .Net 5 01-15-2004 05:35 PM
RecordSet.Move or RecordSet.AbsolutePosition?? Hung Huynh ASP General 8 09-24-2003 11:07 AM
Vb6 object returning ADO Recordset - Error in .NET Developer ASP .Net 0 08-11-2003 03:27 PM



Advertisments