Sylvain Pointeau wrote: > please could someone help me to understand ICU inside SQLite? > > I have some text fields for the German language. > I load the collation with : > SELECT icu_load_collation('de_DE', 'GERMAN'); > > the sort order is good, means it sorts correctly the ä,ö etc > > but it doesn't try to select: > "ä" if I use "ae" > "ü" if I use "ue" > > is it normal?
Yes. Just because 'ä' sorts near 'ae' doesn't mean they are equal. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users