[rygel] media-export: Use proper collation



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]