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:
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:
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.