classic asp character encoding

Blackhood

New Member
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 which is then stored in our DB. I can see in the database that the character is not stored correctly. For example the first name looks like \[code\]M?a\[/code\] where it should be \[code\]Ma\[/code\].When I then read that data and display it in a text box it is still displaying \[code\]M?a\[/code\]. things I've tried:
  • \[code\]<%@ Language=VBScript codepage=65001 %><% Response.Charset="UTF-8" %>\[/code\]
  • 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?
 
Back
Top