Michael Hunley wrote:
At 07:14 PM 2/24/2004 +0100, Eric Morand wrote:
Celine
Céline
Eric
Marc
Éric
Zoe
céline
eric
Éric
éric
This does NOT appear ordered to me...
Moreover, it does not appear correct! "Éric" appears twice, once before
"Zoe" and again before "éric". Why is that?
It looks like it is going on strict ASCII numeric order (a la strcmp),
with the exception of the error I mention above.
SQLite sorts text fields in memcmp() order. This is intentional.
It is not a bug.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
