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]