Implemented as a custom collation because the only collation
supported by SQLite natively is binary, which is cas-sensitive.
---
src/gpodder/dbsqlite.py | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/src/gpodder/dbsqlite.py b/src/gpodder/dbsqlite.py
index 6de173d..91e8533 100644
--- a/src/gpodder/dbsqlite.py
+++ b/src/gpodder/dbsqlite.py
@@ -60,6 +60,7 @@ class Storage(object):
t = thread.get_ident()
if t not in self._db:
conn = sqlite.connect(self.settings['database'])
+ conn.create_collation("unicode", lambda a, b: cmp(a.lower(),
b.lower()))
self._db[t] = conn
log('SQLite connection for thread %d opened.', t)
return self._db[t]
@@ -180,7 +181,7 @@ class Storage(object):
WHERE
(deleted IS NULL OR deleted = 0)
ORDER BY
- title
+ title COLLATE unicode
""")
result = []
--
1.5.4.3
_______________________________________________
gpodder-devel mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/gpodder-devel
