Re: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

[Eric Morand]

This was a mistake by me ! Here is the order actually returned by 
SQLite :

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]