You can see how some people handle this situation here, Sylvain:
http://php.net/manual/de/normalizer.normalize.php
If you want umlauted 'a' (ä) to be treated the same as the two
characters 'ae' (such treatment is an older convention from the days of
typewriters later adopted for ASCII) the application typically does a
normalization of the Unicode character into an ASCII representation: ä
=> ae.
In Unicode umlauted 'a' (ä) is canonically equivalent to 'a' +
combining diaresis but not 'a' + 'e'.
Regards
Tim Romano
On 12/19/2009 4:07 PM, Sylvain Pointeau wrote:
> Hi,
>
> 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?
>
> Many thanks in advance for your help,
>
> Best regards,
> Sylvain
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.427 / Virus Database: 270.14.114/2575 - Release Date: 12/19/09
> 08:33:00
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
