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
