Re: Re: [firebird-support] Case and Accent insensitive compares

Thu, 16 Jun 2016 02:09:59 -0700 

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 [email protected] 
[firebird-support] <[email protected]> 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
___
 

Reply via email to