Hello!
You can add code for load collation for all database connections.
As example, in function sqlite3IcuInit() before "return rc;" add these lines:
UErrorCode status = U_ZERO_ERROR;
UCollator *pUCollator = ucol_open("ru_RU", &status);
if( !U_SUCCESS(status) ){
return SQLITE_ERROR;
}
rc = sqlite3_create_collation_v2(db, "russian", SQLITE_UTF16, (void
*)pUCollator,.
icuCollationColl, icuCollationDel
);
if( rc!=SQLITE_OK ){
ucol_close(pUCollator);
}
And you collation will be loaded automatically:
$ sqlite3
SQLite version 3.6.18
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma collation_list;
0|russian
1|NOCASE
2|RTRIM
3|BINARY
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
