diff options
| -rw-r--r-- | contexts.c | 2 | ||||
| -rw-r--r-- | networks.c | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/contexts.c b/contexts.c index e7f44e4..39974bb 100644 --- a/contexts.c +++ b/contexts.c @@ -38,7 +38,7 @@ const char *ContextsQuery = SQL( SELECT name, query FROM contexts WHERE network = :network AND query <= NOT :public - ORDER BY query, name + ORDER BY query, name COLLATE NOCASE ) SELECT name, query, 1 FROM activeContexts UNION ALL diff --git a/networks.c b/networks.c index 4fcd476..c0f171a 100644 --- a/networks.c +++ b/networks.c @@ -36,7 +36,7 @@ const char *NetworksQuery = SQL( ), allNetworks AS ( SELECT DISTINCT network FROM contexts - ORDER BY network + ORDER BY network COLLATE NOCASE ) SELECT network, 1 FROM activeNetworks UNION ALL |