Sqllite Order by

[Prosg]

Hello,

I have a strange result with this :

Cursor1 = SQL1.ExecQuery("SELECT numeroBoite, nomSociete, nomContact, email, qrcode, derniereNotification FROM clients ORDER BY nomSociete ASC")

the order is :

O...
a...
b...
c...
d...

Why the o is different of O

How can i resolve this if users write maj and no maj text ?

 

[Roger Garstang]

In char order, uppercase are before lowercase. Some SQL languages allow you to declare if you care about case, but I don't believe I've seen it in SQLite. Best thing to do would be converting all entries to a specific case when writing to the database.

 

[Mahares]

You can do this. It will sort them regardless of upper or lower case and it will not physically modify your data. C'est tout ce qu 'il faut.

Cursor1 = SQL1.ExecQuery("SELECT numeroBoite, nomSociete, nomContact, email, qrcode, derniereNotification FROM clients ORDER BY UPPER(nomSociete)")

You do not need ASC if the sort is ascending.

 

[Prosg]

thx a lot

 

[GaryK4]

I Believe that this should work also.

Cursor1 = SQL1.ExecQuery("SELECT numeroBoite, nomSociete, nomContact, email, qrcode, derniereNotification FROM clients ORDER BY nomSociete COLLATE nocase")