Hi, We can use ICU collation to sort text base on locale by using : a. .load './libSqliteIcu.so' b. SELECT icu_load_collation('en_EN', 'ENGLISH'); c.SELECT * FROM Persons ORDER BY LastName COLLATE ENGLISH;
But now i want to customize ICU Collation rule & then use it with Sqlite3. Can any one please help me to know that: a.How to use customize icu collation rules with Sqlite3 to sort text ? b.If we can use both "locale base collation & customize collation" of ICU at same in Sqlite3 to sort text ? if yes, then how ? Thanks in advance. With Regards Ashish "Be a Part of Solution" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users