Celine C�line Eric Marc Zoe c�line eric �ric �ric
Do someone know how to have the ORDER BY statement return values ordered with anything else that memcmp() order ? This method completely make the ORDER BY useless when dealing with accented caracters...
Le 25 f�vr. 04, � 16:11, [EMAIL PROTECTED] a �crit :
Hi,
[ ... ]�ric[ ... ]Zoe�ric
SQLite sorts text fields in memcmp() order. This is intentional. It is not a bug.
But isn't it strange that "�ric" seems to be both (less than or equal) and
(greater than or equal) "Zoe", assuming both "�ric"s are equal?
wondering, /eno
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
