summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--contexts.c2
-rw-r--r--networks.c2
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