MySQL Database Charset
Posted on 2009-04-03
I have a mysql database and the data is stored as UTF-8. This works fine for the primary site using it (blog), but I'm also make remote calls to the database from ASP website. When doing this, I get bad characters back from the database.
For example, curly apostrophes and mdashes are stored in mysql as UTF-8 unicode, but when calling the data remotely, I get back garbled characters when doing response.write()
I have changed the response.charset to UTF-8 as well as ISO ... but neither works.