Hi,

I'm using MySQL Connector/ODBC v5 to connect to a MySQL 4.1.22 server.
I'm using the following connection string:

DRIVER={{MySQL Connector/ODBC
v5}};SERVER={0};DATABASE={1};UID={2};PWD={3};OPTIONS=3;CHARSET=utf8;

The tables are of type MyISAM, the collations are utf8_general_ci.
When inserting rows into a table, any special characters like German
umlauts are written correctly into the table (verified that with
phpMyAdmin). But when reading those rows, the special characters are broken.

If I execute "SET CHARACTER SET latin1" right after connection opening,
the special characters are okay, but I'd like to use UTF-8 only.

What am I doing wrong?

Timo
--
www.TimoSoft-Software.de - Unicode controls for VB6
"Those who sacrifice freedom for safety deserve neither."

Archived from group: microsoft>public>dotnet>framework>odbcnet