Re: Re: Fwd: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread g...@liconic.com [firebird-support]
I'm out of the office till the 18th of October with a limited access to my emails. With the best wishes, Georgiy Kovalov

Re: Fwd: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra luis.fo...@gmail.com [firebird-support]
nonomura nono181...@yahoo.co.jp [firebird-support] < firebird-support@yahoogroups.com> escreveu no dia terça, 16/10/2018 à(s) 15:14: > > > Analitico and all, > > I found that if I add the a extra field in the index like the pk and make > the index unique it works fine. > > > Many of those

Re: Fwd: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-16 Thread hv...@users.sourceforge.net [firebird-support]
> Many of those collation problems seem to relate to unicode_ci and > unicode_ci_ai, > and this relates to the usage of ICU functions. > > FB seems to set collation strength properly only where it relates to unique > index. > Otherwise the strength is left default, i.e. equivalent of collate

Re: Fwd: [firebird-support] Re: Firebird 3.0.4 unicode_ci_ai index problems

2018-10-16 Thread nonomura nono181...@yahoo.co.jp [firebird-support]
Analitico and all, I found that if I add the a extra field in the index like the pk and make the index unique it works fine. Many of those collation problems seem to relate to unicode_ci and unicode_ci_ai, and this relates to the usage of ICU functions. FB seems to set collation strength