ADO recordset returns UTF8 instead ISO-8859-1

F

Frakes

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">
 
A

Anthony Jones

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top