[tracker/collation: 10/10] collation on indices

[Aleksander Morgado <aleksm src gnome org>]

commit 9c23e18bf8457ad17bbc1639672e556e85052751
Author: Aleksander Morgado <aleksander lanedo com>
Date:   Tue Aug 17 15:53:52 2010 +0200

    collation on indices

 src/libtracker-data/tracker-data-manager.c |   14 +++++++-------
 1 files changed, 7 insertions(+), 7 deletions(-)
---
diff --git a/src/libtracker-data/tracker-data-manager.c b/src/libtracker-data/tracker-data-manager.c
index d8359b3..b11cd9c 100644
--- a/src/libtracker-data/tracker-data-manager.c
+++ b/src/libtracker-data/tracker-data-manager.c
@@ -120,11 +120,11 @@ set_secondary_index_for_single_value_property (TrackerDBInterface *iface,
 	                                    field_name);
 
 	if (enabled) {
-		g_debug ("Creating index: CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\", \"%s\")",
+		g_debug ("Creating index: CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\" COLLATE TRACKER ASC, \"%s\" COLLATE TRACKER ASC)",
 		         service_name, field_name, service_name, field_name, second_field_name);
 
 		tracker_db_interface_execute_query (iface, NULL,
-		                                    "CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\", \"%s\")",
+		                                    "CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\" COLLATE TRACKER ASC, \"%s\" COLLATE TRACKER ASC)",
 		                                    service_name,
 		                                    field_name,
 		                                    service_name,
@@ -148,11 +148,11 @@ set_index_for_single_value_property (TrackerDBInterface *iface,
 	                                    field_name);
 
 	if (enabled) {
-		g_debug ("Creating index: CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\")",
+		g_debug ("Creating index: CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\" COLLATE TRACKER ASC)",
 		         service_name, field_name, service_name, field_name);
 
 		tracker_db_interface_execute_query (iface, NULL,
-		                                    "CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\")",
+		                                    "CREATE INDEX \"%s_%s\" ON \"%s\" (\"%s\" COLLATE TRACKER ASC)",
 		                                    service_name,
 		                                    field_name,
 		                                    service_name,
@@ -173,13 +173,13 @@ set_index_for_multi_value_property (TrackerDBInterface *iface,
 
 	if (enabled) {
 		tracker_db_interface_execute_query (iface, NULL,
-		                                    "CREATE INDEX \"%s_%s_ID\" ON \"%s_%s\" (ID)",
+		                                    "CREATE INDEX \"%s_%s_ID\" ON \"%s_%s\" (ID COLLATE TRACKER ASC)",
 		                                    service_name,
 		                                    field_name,
 		                                    service_name,
 		                                    field_name);
 		tracker_db_interface_execute_query (iface, NULL,
-		                                    "CREATE UNIQUE INDEX \"%s_%s_ID_ID\" ON \"%s_%s\" (\"%s\", ID)",
+		                                    "CREATE UNIQUE INDEX \"%s_%s_ID_ID\" ON \"%s_%s\" (\"%s\" COLLATE TRACKER ASC, ID COLLATE TRACKER ASC)",
 		                                    service_name,
 		                                    field_name,
 		                                    service_name,
@@ -191,7 +191,7 @@ set_index_for_multi_value_property (TrackerDBInterface *iface,
 		                                    service_name,
 		                                    field_name);
 		tracker_db_interface_execute_query (iface, NULL,
-		                                    "CREATE UNIQUE INDEX \"%s_%s_ID_ID\" ON \"%s_%s\" (ID, \"%s\")",
+		                                    "CREATE UNIQUE INDEX \"%s_%s_ID_ID\" ON \"%s_%s\" (ID COLLATE TRACKER ASC, \"%s\" COLLATE TRACKER ASC)",
 		                                    service_name,
 		                                    field_name,
 		                                    service_name,