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 dog pushed the ball away with a paw) And this is the correct sorting order, because CCS have to transfered in your mind to CSCS when you order the words.... This has a very logical reason, but I will not bore you with this... :) András -----Original Message----- From: Omacht András [mailto:omacht.and...@libra.hu] Sent: Saturday, November 6, 2021 2:09 PM To: For discussion among Firebird Developers <firebird-devel@lists.sourceforge.net> 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, 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, G, Gy, H, I, Í, J, K, L, Ly, M, N, Ny, O, Ó, Ö, Ő, P, Q, R, S, Sz, T, Ty, U, Ú, Ü, Ű, V, W, X, Y, Z, Zs I can't imagine how can it be solved easily. Maybe if you find double letters you handled them together when you sort and you handled them separated when you search. (Maybe we make smaller sorting mistakes by handling the possible double letters together, because the suffixes are always at the end of the words, and there is less chance to cause a sorting error.) András -----Original Message----- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Saturday, November 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" 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 is > different than "ZS" and "CS" letters. > What about order in the both cases? How is ZS (contraction) and ZS (non-contraction) ordered in relation to others characters? Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
