-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alexey Pechnikov wrote: > 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.
That code should be tidied up a bit. It has copied several functions from the SQLite source, and left them named using a sqlite3 prefix so it will clash if included in the same file as the amalgamation. The final results will be significantly better than the original proposal here, but since it is locale independent they will not be accurate for all locales. For example German uses a different sort order for names (eg phone book) vs dictionary, Swedish uses a different sort order for accented characters than German etc, and so any locale independent sorting will not be 100% correct. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkm/80cACgkQmOOfHg372QToDwCgo3j7m6FV9Sdhn423uqL6I/q8 vEMAnR9bblsCe0LiRwSLyoFM/P4M3/sV =nK/M -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
