Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Omacht András
this before, Hungarian is my mother tongue, not my profession. :))) -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Saturday, November 6, 2021 2:35 PM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Adriano dos Santos Fernandes
On 06/11/2021 10:08, Omacht András wrote: > Yes, this is a huge problem. When you order you have to know CS is CS or C > and S. > > E.g.: > CICA > CUKOR > CSIGA > is the good order, not > CICA > CSIGA > CUKOR > even though S is ahead of ABC than U because C is ahead of CS and in CSIGA CS > is

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Omacht András
[mailto:omacht.and...@libra.hu] Sent: Saturday, November 6, 2021 2:09 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915 Yes, this is a huge problem. When you order you have to know CS is CS or C and S. E.g.: CICA CUKOR CSIGA is the good order

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Dimitry Sibiryakov
Omacht András wrote 06.11.2021 14:08: Maybe if you find double letters you handled them together when you sort and you handled them separated when you search. Unfortunately comparison is used for sorting and sorting is used for indexes and indexes are used for search so they cannot have

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Omacht András
6, 2021 1:45 PM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915 On 06/11/2021 09:19, Omacht András wrote: > It is a rule, but hungarian languages have some of this "rules" / "cases". > > "SÁG"/"SÉG&quo

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Omacht András
, November 6, 2021 1:09 PM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915 2021.11.06. 12:35 keltezéssel, Omacht András írta: > > Gábor, am I correct? > I think yes. But at searching as a user I want to get ZEBRA and ZSIRÁF too if use

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Adriano dos Santos Fernandes
On 06/11/2021 09:19, Omacht András wrote: > It is a rule, but hungarian languages have some of this "rules" / "cases". > > "SÁG"/"SÉG" is a suffix, you can make new words (adjective -> noun) using it. > > IGAZ -> TRUE > IGAZSÁG -> TRUTH > ÍNYNEC -> GOURMET > ÍNYENCSÉG -> DELICACY > > In this

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Omacht András
S és CS are two different letters and its pronunciation is different than "ZS" and "CS" letters. András -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Saturday, November 6, 2021 12:50 PM To: For discussion among Firebird Develo

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Gabor Boros
2021.11.06. 12:35 keltezéssel, Omacht András írta: Gábor, am I correct? I think yes. But at searching as a user I want to get ZEBRA and ZSIRÁF too if use starting with 'Z'. :-) Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Adriano dos Santos Fernandes
On 06/11/2021 08:35, Omacht András wrote: > For example, in the word of "IGAZSÁG", ZS is not a letter, but here two, a Z > and an S. Is it an exception to the rule or it it another rule? Adriano Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Dimitry Sibiryakov
Omacht András wrote 06.11.2021 12:35: However, I am not sure whether it is not a better result for the average user today, (e.g. in a quick search) if all appear after typing C... AFAIU only "dictionary collations" are using contractions so developers of applications for average users can

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Omacht András
1 11:54 AM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915 Gabor Boros wrote 05.11.2021 16:39: > 2021.11.05. 12:36 keltezéssel, Pavel Cisar írta: >> However, the Czech language defines only one contraction (CH), but >> there are

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-06 Thread Dimitry Sibiryakov
Gabor Boros wrote 05.11.2021 16:39: 2021.11.05. 12:36 keltezéssel, Pavel Cisar írta: However, the Czech language defines only one contraction (CH), but there are other languages that have many such as Hungarian. Yes: cs, dz, gy, ly, ny, sz, ty, zs and dzs. Sorry. :-) Is it ok from the

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Gabor Boros
2021.11.05. 12:36 keltezéssel, Pavel Cisar írta: However, the Czech language defines only one contraction (CH), but there are other languages that have many such as Hungarian. Yes: cs, dz, gy, ly, ny, sz, ty, zs and dzs. Sorry. :-) Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Adriano dos Santos Fernandes
On 05/11/2021 08:54, Alex Peshkoff via Firebird-devel wrote: > > Before changing / fixing something we should first of all decide what > result do we really need. > Please also take into account that what the customer primary problem was the unacceptable performance degradation when they switch

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Pavel Cisar
Hi, Dne 05. 11. 21 v 12:54 Alex Peshkoff via Firebird-devel napsal(a): Pavel - how this SHOULD be in firebird from big clients POV? STARTING WITH "HROC" should return only HROCENI or HROCH too? They prefer that "C" should NOT match "CH" (which is also how Oracle and SQLServer do it). Fact

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/5/21 2:36 PM, Pavel Cisar wrote: For example: The key "HROCH" (Czech word for hippopotamus) could have sortkey: 13+27+23+14 (each letter replaced with byte representing it's order place in alphabet, which is simplification for this showcase, i.e. 13=H 27=R 23=O 14=CH) If you would

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Pavel Cisar
Hi, Dne 04. 11. 21 v 16:56 Karol Bieniaszewski napsal(a): „The main reason why this "removal of trailing partial contraction" was done is to achieve behavior "consistent" with search/evaluation in other software (like text editors etc.), so (for example) STARTING WITH "C" or LIKE "C%" will

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/4/21 6:56 PM, Karol Bieniaszewski wrote: „The main reason why this "removal of trailing partial contraction" was done is to achieve behavior "consistent" with search/evaluation in other software (like text editors etc.), so (for example) STARTING WITH "C" or LIKE "C%" will return rows

[Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-04 Thread Karol Bieniaszewski
„The main reason why this "removal of trailing partial contraction" was done is to achieve behavior "consistent" with search/evaluation in other software (like text editors etc.), so (for example) STARTING WITH "C" or LIKE "C%" will return rows starting with "C" or "CH". This behavior itself