Posts tagged “mysql”

Classic ASP, MySQL and UTF-8

Countless references on the web will tell you that you can access Unicode data in MySQL by setting the connection character set to utf8. Mostly, they tell you to execute the statement "set names 'utf8'" as the first statement in your connection. But when you are accessing MySQL from Classic ASP using the MySQL ODBC driver, you get an error: "SET NAMES not allowed by driver". Here's how you actually do it in Classic ASP.