Problem with Croatian specific letters

Davor Dundovic <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
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.


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.