> -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
>
>
>
> Unfortunately, in neither of these cases will SQLite use an index to
perform
> the sort or retrieval. So you won't get the performance of, say, mysql's
> text fields:
>
> http://www.mysql.com/doc/en/CHAR.html
>
> -Ken
>
Another solution that would allow using an index would be to add
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
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
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
Hi to all,
I've noticed a strange behavior with the SELECT...ORDER BY...
statement. Maybe this is a feature but that still bugs me...
Here is a part of my database :
Table : Thirds
Column : Name
Entres : Eric, Céline, éric, Éric, Celine, Marc, eric, céline, Zoe.
When I perform this query to
6 matches
Mail list logo
