Problem with Croatian specific letters - Davor Dundovic - com.mysql.lists.win32

1 message in com.mysql.lists.win32Problem with Croatian specific letters

From	Sent On	Attachments
Davor Dundovic	16 Jul 2006 11:00

Subject:	Problem with Croatian specific letters
From:	Davor Dundovic (dun...@montelektro.com)
Date:	07/16/2006 11:00:53 AM
List:	com.mysql.lists.win32

Hi all !

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

I have problem with Croatian specific letters (ðÐèÈæÆ).

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

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

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

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

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

Regards, Dundo.