-----BEGIN PGP SIGNED MESSAGE-----
Zsolt Koppany wrote:
> we use mysql-3.23.5x? under Linux and cannot upgrade to 4.x. Our java
> applications can store and fetch UTF-8 characters we have problem only
> Any ideas how I can fix the problem?
If you can't upgrade to 4.1 (where you could apply a collation to your
sort), you will have to do your sorting _outside_ of MySQL, and _after_
you've converted your UTF-8 characters to full unicode characters (and
even then, you will need to pick a collation for sorting).
UTF-8 encoded characters have no real sorting order (there is a
'natural' one that works for some cases, but not all). UTF-8 is an
_encoding_ that can encode many different unicode character sets, it's
not a character set itself (like latin1, Cp1250, etc), so the notion of
'sorting' doesn't really make sense with it.
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
Are you MySQL Certified?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----