Hello! On Thursday 12 March 2009 10:09:28 Roger Binns wrote: > > I was asking the group their opinion about the usefulness of such > > feature. > > As described I think it is mostly useless. Sorting even just for West > European languages is not trivial. For example some countries have a > different sort order for using names vs in the dictionary. (This > complexity is part of the reason why ICU is so large.) As described it > would only get things mostly right. That is why I suggested documenting > where it gets things wrong - for example grab some random Italian, > Swedish, Flemish etc text and sort using your algorithm and using ICU > and compare the results. If your algorithm is "wrong" 0.001% of the > time then it is very useful to many people. If it is "wrong" 40% of the > time then it would only be useful in a limited set of circumstances
You can find locale-independant Unicode extension here: http://ioannis.mpsounds.net/blog/2007/12/19/sqlite-native-unicode-like- support/ This work fine for me and about 4x faster than ICU. Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
