Prosg Active Member Licensed User Longtime User Feb 4, 2013 #1 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 ?
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 ?
R Roger Garstang Well-Known Member Licensed User Longtime User Feb 4, 2013 #2 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. Upvote 0
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.
M Mahares Expert Licensed User Longtime User Feb 4, 2013 #3 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. Code: Copy 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. Upvote 0
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. Code: Copy 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.
G GaryK4 Member Licensed User Longtime User Feb 4, 2013 #5 I Believe that this should work also. Cursor1 = SQL1.ExecQuery("SELECT numeroBoite, nomSociete, nomContact, email, qrcode, derniereNotification FROM clients ORDER BY nomSociete COLLATE nocase") Upvote 0
I Believe that this should work also. Cursor1 = SQL1.ExecQuery("SELECT numeroBoite, nomSociete, nomContact, email, qrcode, derniereNotification FROM clients ORDER BY nomSociete COLLATE nocase")
