List:General Discussion« Previous MessageNext Message »
From:Mark Matthews Date:November 29 2003 5:03pm
Subject:Re: UFT-8 support under mysql-3.23.5x?
View as plain text  
-----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-----

Thread
UFT-8 support under mysql-3.23.5x?Zsolt Koppany27 Nov
  • Re: UFT-8 support under mysql-3.23.5x?Stefan Hinz27 Nov
  • Re: UFT-8 support under mysql-3.23.5x?Mark Matthews29 Nov