RE: FN-FORUM: MySQL, ASP.NET and Chinese PRC

date posted 9th August 2007 18:37

Hi Adam,

All that's been done already thanks. The issue appears to be ODBC connector
but I can't find any actual instructions on syntax or usability that makes
sense in the current application.

You only get marmite if you can tell me if the MySQL ODBC 3.51.18 connector
will pass Chinese characters for both classic ASP and ASP.NET. What needs
to be in the connection strings and are there any other things that need to
be done like issuing a "SET NAMES utf8" instruction, but if so, how do you
do it, where and when?

You see, this site front end is AHTML ASP.NET VB V1.1 but the CMS is XHTML
classic ASP. Both use the same ODBC connector. Don't ask, I didn't write it,
but I now have to have it spitting out Chinese text and soon!

Shall I pop out to Sainsbury's?

Craig

-----Original Message-----


Craig wrote:
> Hi there,
>
> I'm now getting desperate. Is there anyone out there with experience of
> using MySQL 5.0, ASP.NET VB V1.1 and ODBC 3.51 connector to drive a site
> that can potentially have European and Chinese (PRC) characters displayed.
>
Just a quick thought, MySQL does not by default create tables in UTF-8
format. Have you ensured that this is switched on? Basically check that
ASP.NET also understands that this stuff is UTF-8 and also ensure your
html states that this is UTF-8

That *should* solve the problem.

If it does, I'll email you address and you can send me a jar of marmite :)