I'm having a problem with Spanish characters in a classic asp site. A user is able to submit their name/address in a form on an aspx page. The aspx page then does an ajax post to a classic asp page which all it does is stored in our Sql 2008 DB. I can see in the database that the character is not stored correctly. For example the first name looks like Mª
where it should be Mª
.
When I then read that data and display it in a text box it is still displaying Mª
.
things I've tried:
<%@ Language=VBScript codepage=65001 %>
<% Response.Charset="UTF-8" %>- encoding file as UTF-8 (using notepad++)
any other ideas? Do I need to go back into the database and fix the characters first or can this be done when I read the characters and display them?
Best Answer
I had same problem when started using utf-8 on ASP, found that session.CodePage makes the difference. In classic ASP pages do always this first ASP declarations to ensure all page uses UTF-8 for data, forms, asp code, data received or sent.