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

16.06.2016 15:30, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: > How can I work with that DE_DE_AI collation you mention? Firebird > doesn't seem to know it. According to README.intl you must create it in database using CREATE COLLATION query. I hope Adriano can shed more

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

> UNICODE_AI collation is useless, but DE_DE_AI can work unless Stefan > needs to keep words in other languages in the same field as well. That's the point. I don't know what language is used (can be every European language) and so I'll have to live with that. How can I work with that DE_DE_AI

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

16.06.2016 11:33, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > unless Tomas need to keep words Oops, it was Stefan, of course. I'm sorry. -- WBR, SD.

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

16.06.2016 11:03, Paul Vinkenoog p...@vinkenoog.nl [firebird-support] wrote: > 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 >

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

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 p...@vinkenoog.nl [firebird-support] napisał:   Hi Stefan, > > Also, it is questionable if

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

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

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

Hi, you use wrong collation UNICODE_CI is truly case-insensitive. In a search for e.g. 'Apple', it will also find 'apple', 'APPLE' and 'aPPLe'. UNICODE_CI_AI is accent-insensitive as well. According to this collation, 'APPEL' equals 'Appèl'. as you can see UNICODE_CI_AI is accent-insensitive

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

> 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

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

Hello Stefan, > I expect that an accent insensitive compare treats accented characters > as the "same" as their un-accented counterparts because the accent > does not change the character itself but things like pronounciation or > stress. > > So in Frech, à is similar to a, é is similar to è and

[firebird-support] Case and Accent insensitive compares

I expect that an accent insensitive compare treats accented characters as the "same" as their un-accented counterparts because the accent does not change the character itself but things like pronounciation or stress. So in Frech, à is similar to a, é is similar to è and you use an accent