diff options
| author | June McEnroe <june@causal.agency> | 2020-07-11 19:05:48 -0400 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2020-07-11 19:05:48 -0400 |
| commit | c68d3c98973c276c46227db0e3968b4e97d90831 (patch) | |
| tree | 1b074cc8010631b991ae3922f4bf132d820b2713 | |
| parent | Dim search result context links (diff) | |
| download | scooper-c68d3c98973c276c46227db0e3968b4e97d90831.tar.gz scooper-c68d3c98973c276c46227db0e3968b4e97d90831.zip | |
Sort networks and contexts case-insensitively
| -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 |