Subject Re: Re: [firebird-support] Case and Accent insensitive compares
Author liviuslivius
Hi,
 
you have right Paul and Stefan
sorry for previous answer - i miss that point
 
regards,
Karol Bieniaszewski
 
W dniu 2016-06-16 11:03:25 użytkownik Paul Vinkenoog paul@... [firebird-support] <firebird-support@yahoogroups.com> napisał:
 

Hi Stefan,

> > Also, it is questionable if you should consider a and ä different
> > letters, even in German. See e.g.
> > https://de.wikipedia.org/wiki/Alphabetische_Sortierung
>
> For sorting, treating them as "same" is correct. However, for things
> like comparisons (in a unique key for example) they are not the same.

That's right. I can't think of any circumstances where you would want
to consider 'hatten' and 'hätten' the same, for instance. Or Mutter and
Mütter. Actually, I couldn't think of any German word where this would
be the case. So when it's strictly about German, AI collations seem
useless, except for catching certain foreign words and names likes
Gérard/Gerard, or misspellings of Kekulé.

Cheers,
Paul Vinkenoog

___