but in german, "*schön*<http://www.dict.cc/deutsch-englisch/sch%C3%B6n.html>"
can be written "schoen" right?
On Sat, Dec 19, 2009 at 10:16 PM, Igor Tandetnik <itandet...@mvps.org>wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
