[Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra
| 0 | 2 | 0 | 1 | 0 | 0 |0 |0 |0 | |M_UNICODE | 0 | 2 | 0 | 1 | 0 | 0 |0 | 0 | 0 | +---+---+--

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra
> Can you please explicitly describe the problem, instead of expecting us > to interpret the output and try to figure out what problem you see here? > > Mark > > On 17-10-2018 19:47, Luis Forra wrote: > > After discussing in firebird-suport I believe that this is relevant

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra
ribe the problem, instead of expecting us > to interpret the output and try to figure out what problem you see here? > > Mark > > On 17-10-2018 19:47, Luis Forra wrote: > > After discussing in firebird-suport I believe that this is relevant to > > this list > > >

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra
Mark, was you that advised me to put the question in firebird-suport in the first place. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Luis Forra
lem explicit by describing it. > That is especially important if you want people to actually reply and > address your problem. Questions without an explicit problem statement > are far more likely to go unanswered You are right of course, my mistake Luis Forra --- Firebird-Devel

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-18 Thread Luis Forra
most of indexes to unique by adding the primary key in the end, as they are numeric, in that case the querys (varchar,varchar,numeric unique) work as expected, but with foreign keys there isn't that option. regards Luis Forra --- Adriano dos Santos Fernandes escreveu no dia quinta, 18/10

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5947) UTF8 Collation UNICODE_CI_AI not working as expected causing poor performance in database

2018-10-19 Thread Luis Forra
didn't notice but you can replicate the problem ? Yes in the tracker there is a reference to CORE-5940 I'am sure that will be solved regards Luis Forra --- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-24 Thread Luis Forra
gt; UNICODE collation doesn't affect the performance of the database, with UNICODE_CI_AI I can't use foreign keys with two varchar, I had to drop all. Luis Forra --- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-27 Thread Luis Forra
nonomura escreveu no dia sexta, 26/10/2018 à(s) 03:00: > > > > > > > > > >> https://github.com/Alexpux/firebird-git-svn/blob/master/src/common/unicode_util.cpp#L1334 > > > > > > > > > Just a heads up: that is an outdated clone of an old repository that > > > was synced from subversion and

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-29 Thread Luis Forra
tial match, somehow in the case of CI and CI_AI is flawed Luis Forra --- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5947) UTF8 Collation UNICODE_CI_AI not working as expected causing poor performance in database

2018-10-19 Thread Luis Forra (JIRA)
Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 3.0.4 Environment: Windows x64 superserver, Linux x64 superserver Reporter: Luis Forra When migrating to utf8 with collation UNICODE_CI_AI I starting to note major