Fossil SCM
Use "COLLATE nocase" when listing user names.
Commit
439453b5c77ab790865e454c92d89378a22c01ff
Parent
bc04f483f95c503…
1 file changed
+1
-1
+1
-1
| --- src/setup.c | ||
| +++ src/setup.c | ||
| @@ -151,11 +151,11 @@ | ||
| 151 | 151 | "SELECT uid, login, cap, info, 1 FROM user" |
| 152 | 152 | " WHERE login IN ('anonymous','nobody','developer','reader') " |
| 153 | 153 | " UNION ALL " |
| 154 | 154 | "SELECT uid, login, cap, info, 2 FROM user" |
| 155 | 155 | " WHERE login NOT IN ('anonymous','nobody','developer','reader') " |
| 156 | - "ORDER BY 5, 2" | |
| 156 | + "ORDER BY 5, 2 COLLATE nocase" | |
| 157 | 157 | ); |
| 158 | 158 | while( db_step(&s)==SQLITE_ROW ){ |
| 159 | 159 | int iLevel = db_column_int(&s, 4); |
| 160 | 160 | const char *zCap = db_column_text(&s, 2); |
| 161 | 161 | const char *zLogin = db_column_text(&s, 1); |
| 162 | 162 |
| --- src/setup.c | |
| +++ src/setup.c | |
| @@ -151,11 +151,11 @@ | |
| 151 | "SELECT uid, login, cap, info, 1 FROM user" |
| 152 | " WHERE login IN ('anonymous','nobody','developer','reader') " |
| 153 | " UNION ALL " |
| 154 | "SELECT uid, login, cap, info, 2 FROM user" |
| 155 | " WHERE login NOT IN ('anonymous','nobody','developer','reader') " |
| 156 | "ORDER BY 5, 2" |
| 157 | ); |
| 158 | while( db_step(&s)==SQLITE_ROW ){ |
| 159 | int iLevel = db_column_int(&s, 4); |
| 160 | const char *zCap = db_column_text(&s, 2); |
| 161 | const char *zLogin = db_column_text(&s, 1); |
| 162 |
| --- src/setup.c | |
| +++ src/setup.c | |
| @@ -151,11 +151,11 @@ | |
| 151 | "SELECT uid, login, cap, info, 1 FROM user" |
| 152 | " WHERE login IN ('anonymous','nobody','developer','reader') " |
| 153 | " UNION ALL " |
| 154 | "SELECT uid, login, cap, info, 2 FROM user" |
| 155 | " WHERE login NOT IN ('anonymous','nobody','developer','reader') " |
| 156 | "ORDER BY 5, 2 COLLATE nocase" |
| 157 | ); |
| 158 | while( db_step(&s)==SQLITE_ROW ){ |
| 159 | int iLevel = db_column_int(&s, 4); |
| 160 | const char *zCap = db_column_text(&s, 2); |
| 161 | const char *zLogin = db_column_text(&s, 1); |
| 162 |