-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Zsolt Koppany wrote:
> Hi,
>
> 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
with
> sorting.
>
> Any ideas how I can fix the problem?
>
> Zsolt
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.
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
www.mysql.com
Are you MySQL Certified?
http://www.mysql.com/certification/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQE/yNF5tvXNTca6JD8RAuwFAKCskNb6c2VkR13Ek0215gH4dGAxxwCcCuJE
rmOfdxR4op4coIm+McMkrK0=
=NC3f
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
