Sylvain Pointeau <sylvain.point...@gmail.com> wrote: > How does sqlite handle ICU, I don't understand? > is it used only for the sort order?
No, the collation is used both for sorting and for equality check. However, ICU doesn't actually treat 'ä' as equal to 'ae'. You can see for yourself here: http://demo.icu-project.org/icu-bin/locexp?_=de_DE&d_=en&x=col&collation=phonebook Try sorting ae áe ä You'll see they actually get sorted in that order. 'ä' and 'ae' can't possibly be considered equal when there exist strings that sort between them. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users