Lukas Haase wrote: > When I use the ICU module and I create a collation, where is the > collation "stored"?
The collation name is part of the database schema. The actual comparison algorithm is not represented in the database in any way: your application must ensure that all clients install compatible collations behind that name. > Do I have to call icu_create_collation everytime I > start up the database? Every time you open a connection, yes. > Or just one time? Or only when inserting data? > What happens if I omit the call? When you try to prepare a statement that needs the collation, you'll get an error "unknown collation". > This leads to the second question: If I only insert data on the Linux > side and I have an index on the column using the ICU collation, do I > need to have ICU support on client side? Yes, if you run SELECT statements that perform comparisons or sort on columns associated with this collation. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
