Handling special/foreign characters ...
I'm using ASP to query my customer data out of my SQL database.
Sql is returning a street address of "BismarckstraÃe 2" - however when I print the value out on my web page using something like "Response.Write objRS("vchAddress1")" -- I am getting the value "Bismarckstra_e 2". What can I do so that the web page prints the value correctly? I've tackled this problem with encoding and sending values along with URLs, but this is straight from sql to the page - no passing of data.