I have been trying to get sqlite to order a set of entries by name in the following order
AaBbCcDd......Zz
but the closest I've gotten is using COLLATE NOCASE to get a case insensitive sort.
The entries I have are
Addy|2000-01-22T16:06:14.155Z
alice|2000-01-22T16:06:20.514Z
billyRay|2000-01-22T16:06:36.175Z
Bobby|2000-01-22T16:06:26.868Z
claus|2000-01-22T16:06:52.531Z
CoffinLLC|2000-01-22T15:33:11.235Z
Default|2000-01-22T15:55:12.168Z
I have tried the following select statements in the sqlite3 command line to achieve my goal without success.
select * from t1 order by name COLLATE NOCASE asc;
select * from t1 order by name COLLATE NOCASE, name asc;
select * from t1 order by lower(name), name asc;
select * from t1 order by name, lower(name) asc;
Aucun commentaire:
Enregistrer un commentaire