Classic ASP ODBC 3.51 UTF8 problem

Hi,

I have  been asked to convert an Australian web site to handle Chinese
characters.  It has a MySQL 5.0 database and has a front end written in
ASP.NET VB V1.1 and a CMS written in Classic ASP.  I seem to have been
successful in converting the database to UTF-8 and the .NET application as
various extended characters can be input via forms and read back on the web
pages.

I should also say that all pages are XHTML.

My problem comes with the CMS, it neither reads back nor inputs correctly
any extended characters (ø, å, etc).  The pages are using the same database
tables as the .NET front end and have response.charset="utf-8" in each of
them plus the content/type meta tag charset=UTF-8 set ok.  It appears to me
that the ODBC connector isn't carrying the encoding correctly.

The .NET connection string: "Driver={MySQL ODBC 3.51 Driver};
Server=localhost; Port=3306; UID=theDB; PWD=xxxxxxxx; charset=utf8;
OPTION=3; Database=daelive"

The Classic ASP connection string: "Driver={MySQL ODBC 3.51 Driver};
Server=localhost; Port=3306; UID=theDB; PWD= xxxxxxxx; character set=utf8;
OPTION=3; Database=config"

I've added the "charset=utf8" and "character set=utf8" from the results of a
lot of Googling so I'm not positive they are correct.

Could someone please advise as I'm VERY new to MySQL. I'm not even sure that
the non-.NET ODBC driver can handle utf-8 properly.

Best regards,

Craig Stevens
The Incredibly Useful Company Limited
[email protected]
Tel: +44 (0)1753 573510
Fax: +44 (0)870 130 3707
Skype: callto://craig1001
 


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]