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 (=9A=8A=F0=D0=E8=C8=E6=C6=9E=
=8E).

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.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32 [at] m.gmane.org
Davor Dundovic [ So, 16 Juli 2006 20:01 ] [ ID #1393113 ]
Datenbanken » gmane.comp.db.mysql.windows » Problem with Croatian specific letters

Vorheriges Thema: newbie vs the wizards (enable-named-pipe)
Nächstes Thema: Unable to link Microsoft Access with MYSQL