Problem with Croatian specific letters

Hi all !

I'm using MySQL v5.0.21 on Windows 2000 platform.

I have problem with Croatian specific letters (šŠðÐèÈæÆ=9E=
=8E).

Database and tables are created as utf8. I can=20
enter data through MySQL Administrator correctly.

When I do SELECT from my program (I'm using ADO=20
and ODBC), instead of some Croatian specific letters I get "?".

I tried using collations and character sets=20
(latin2 should work), using CHAR and NATIONAL CHAR without success.

Only way I can make it work is to issue "SET=20
NAMES cp1250" query after connecting to database.=20
After that everything works as it should. CP1250=20
is MS Windows collation for Eastern Europe.

I would like to find another way because I think=20
this is only workaround and not the way to go.



Regards, Dundo.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org