[rygel] media-export: Use proper collation
- From: Jens Georg <jensgeorg src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [rygel] media-export: Use proper collation
- Date: Sun, 19 Aug 2012 09:44:32 +0000 (UTC)
commit 04a9048444a22329e4d8b9b78a32c19ea970e232
Author: Jens Georg <mail jensge org>
Date: Sat Aug 18 00:58:33 2012 +0200
media-export: Use proper collation
Use proper collation in query containers.
.../rygel-media-export-sql-factory.vala | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
---
diff --git a/src/plugins/media-export/rygel-media-export-sql-factory.vala b/src/plugins/media-export/rygel-media-export-sql-factory.vala
index 9222fe4..02f9e63 100644
--- a/src/plugins/media-export/rygel-media-export-sql-factory.vala
+++ b/src/plugins/media-export/rygel-media-export-sql-factory.vala
@@ -158,7 +158,8 @@ internal class Rygel.MediaExport.SQLFactory : Object {
private const string GET_META_DATA_COLUMN_STRING =
"SELECT DISTINCT %s AS _column FROM meta_data AS m " +
- "WHERE _column IS NOT NULL %s ORDER BY _column LIMIT ?,?";
+ "WHERE _column IS NOT NULL %s ORDER BY _column COLLATE CASEFOLD " +
+ "LIMIT ?,?";
internal const string schema_version = "11";
internal const string CREATE_META_DATA_TABLE_STRING =
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]