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]
