ADO recordset returns UTF8 instead ISO-8859-1

ADO recordset returns UTF8 instead ISO-8859-1

am 04.04.2007 17:00:40 von 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:
TR/xhtml11/DTD/xhtml11.dtd">

I am using following contenttype:
charset=3Diso-8859-1">

Re: ADO recordset returns UTF8 instead ISO-8859-1

am 05.04.2007 10:27:07 von Anthony Jones

>>>>>>
"Frakes" wrote in message
news:1175698840.014825.62970@e65g2000hsc.googlegroups.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:
TR/xhtml11/DTD/xhtml11.dtd">

I am using following contenttype:

<<<<<<

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.