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" <[EMAIL PROTECTED]>
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/[EMAIL PROTECTED]

Reply via email to