Hi Simon > Given the declared setup we have two concerns: > 1) dependent on system locale which can be changed
As I already mentioned in one of previous posts: If it proves to be a problem, we can remember used locale and force index rebuild if necessary. (Android version behaves this way already now.) > 2) requires detailed knowledge of individual languages (how many languages > can one person know that well ?) What we need to do is to decide when we can afford to use ascii comparison. I tried to investigate common (i.e. mostly european) latin-based languages and found only the digraph problem - the respective languages are excluded from using ascii optimization. Besides this I am aware of only 1 problem - Swedish should treat v/w identically. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Collation-advice-tp70668p70699.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users