[libgda/LIBGDA_4.2] Correction for bug #651069 - DataProxy improperly sorts utf8 national letters

[Vivien Malerba <vivien src gnome org>]

commit ca1f4f2268535f907f7bb2fb968bf455149ea3b9
Author: Vivien Malerba <malerba gnome-db org>
Date:   Fri May 27 21:40:28 2011 +0200

    Correction for bug #651069 - DataProxy improperly sorts utf8 national letters

 libgda/sqlite/virtual/gda-vprovider-data-model.c |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)
---
diff --git a/libgda/sqlite/virtual/gda-vprovider-data-model.c b/libgda/sqlite/virtual/gda-vprovider-data-model.c
index 3050227..6e476bf 100644
--- a/libgda/sqlite/virtual/gda-vprovider-data-model.c
+++ b/libgda/sqlite/virtual/gda-vprovider-data-model.c
@@ -511,6 +511,8 @@ virtualCreate (sqlite3 *db, void *pAux, int argc, const char *const *argv, sqlit
 		g_string_append (sql, type);
 		if (! gda_column_get_allow_null (column)) 
 			g_string_append (sql, " NOT NULL");
+		if (gtype == G_TYPE_STRING)
+			g_string_append (sql, " COLLATE LOCALE");
 	}
 
 	/* add a hidden column which contains the row number of the data model */