Re: Unicode sorting and binary comparison, please!

[Yves Goergen <nospam.list@xxxxxxxxxxxxxxx>]

On 06.03.2008 15:15 CE(S)T, Paul DuBois wrote:
> Here's some advice from Alexander Barkov:
>
> You might be able to use a particular collation to achieve what you want.
> For example, latin1_general_ci.
> You can take a look at its collation chart here:
> http://www.collation-charts.org/mysql60/mysql604.latin1_general_ci.html
>
> As you can see, all accented letters are considered as separate letters.
> So when you do:
>
> SELECT ... WHERE a='a'
> you only get 'a' and 'A'. But you wan't get any other variants of the 
> letter 'a',

That doesn't support Unicode, right? So it could sort a, ä and à but not 
ā, ă and α. Unicode-capability is a must for my application.

--
Yves Goergen "LonelyPixel" <nospam.list@xxxxxxxxxxxxxxx>
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx