> -Original Message-
> From: Jay Macaulay [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 27, 2004 10:56 AM
>
> Another solution that would allow using an index would be to
> add another
> column, flatname, and insert the name into that column
> without any accents
> while still ins
> -Original Message-
> From: Michael Hunley [mailto:[EMAIL PROTECTED]
>
> Solution 1: implement your own OrderBy function and call that instead
> Solution 2: Implement a Flatten function that converts
> accented characters
> to their non-accented and, optionally, converts all uppercase
At 10:32 AM 2/27/2004 +0100, Eric Morand wrote:
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 metho
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 de
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
---
This was an error when I copied the list...sorry.
Le 25 févr. 04, à 00:19, Michael Hunley a écrit :
Moreover, it does not appear correct! "Éric" appears twice, once
before "Zoe" and again before "éric". Why is that?
-
To unsub
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
7 matches
Mail list logo
