Hi,
I have this problem with czech characters under WIN32 (exactly MySQL ver.
3.23.33, today upgraded to 3.23.39a running on Win98, ODBC ver. 2.50.33):
czech characters š (s with wedge), Š (S with wedge), ž (z with wedge) and Ž
(Z with wedge) are improperly sorted and manipulated (e.g. with lower and
upper functions).
By me this is done by differences in iso latin charset used normally by
MySQL on UNIX installations and charset used by Win32:
- š is 0x9A on WIN32 comparing to 0xB9 used in MySQL
- Š is 0x8A (instead of 0xA9)
- ž is 0x9E (instead of 0xBE)
- Ž is 0x8E (instead of 0xAE).
Is this problem caused by improper setting in e.g. MyODBC driver, or is
there a bug in MySQL?
By me this should be solved by character translations by ODBC driver,
because hard coding charsets into MySQL will do it not platform independent.
Thanks for your help
Vladimir Horsky
