From c68d3c98973c276c46227db0e3968b4e97d90831 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Sat, 11 Jul 2020 19:05:48 -0400 Subject: Sort networks and contexts case-insensitively --- contexts.c | 2 +- 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 -- cgit 1.4.1