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

Yes, the correct order would be IGAZ IGAZSÁG IGAZU IGAZ (4 charater word) IGAZU (5 charater word, 4th is Z and 5th is U) IGAZSÁG (7 charater word 4th is Z and 5th is S which is before U in our ABC) Here to think that 4th character is ZS is incorrect. Try: CICA

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

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

Ok, just as interesting, I don't think it should be programmed in Firebird... :) Sometimes this two-letter characters transformed three-letters characters, but in sorting have to be handled as be the original two-letter character TWICE! E.g. MANCS - PAW MANCCSAL- WITH PAW(My

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

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

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 CS, not C and S. Our ABC is: A, Á, B, C, Cs, D, Dz, Dzs, E, É, F,

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

For me personally i think that only sorting rule have sense not searching rule. I can imagine that in database i have – consider that Harry Potter is written by „Ch” as „Charry Potter”. And i write: Rád čtu knihy o „Charry Potter”. And now i search for ‘%C%’ and i have empty result  because

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

So do I. Although we have such two- or three-character letters in the Hungarian language, I would not deal with them specifically. If only a part of them can be found, I would display them as hits. András -Original Message- From: Gabor Boros [mailto:mlngl...@bgss.hu] Sent: Saturday,

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" 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

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 cases ZS és CS are two different letters and its pronunciation

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 starting with 'Z'. :-) Gabor Firebird-Devel mailing list, web interface at

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

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

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

Yes, if you have these data: ANIMALS table ANIMAL_TYPE CICA CSIGA DARÁZS ZEBRA ZSIRÁF Grammatically the correct solution: select animal_type from animals where animal_type starting with 'C'; CICA select animal_type from animals where animal_type starting with 'CS'; CSIGA select animal_type

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 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

[Firebird-devel] Plans for 3.0.8

Hi All, it's November now. Any chance of coming out in the near future? 3.0.7 was released October 20, 2020. András [cid:image001.png@01D7D2E8.83347DE0] CÉGÜNK A LIBRA CSOPORT TAGJA OMACHT ANDRÁS fejlesztési igazgató LIBRA Szoftver Zrt. 1113 Budapest, Karolina