Hi, On Thu, 2006-10-19 at 18:02 +0300, [EMAIL PROTECTED] wrote: > > From: Peter Gulutzan <[EMAIL PROTECTED]> > > > > MySQL is looking for an authoritative, official statement which states > > all the current Hungarian collation rules. > > According to the Reference Level Description of the hungarian language (ISBN > 9634206441 or the hungarian version on line: > http://bme-tk.bme.hu/other/kuszob/hangok.htm ) the rules are > the following: >
Apparently http://bme-tk.bme.hu/other/kuszob/hangok.htm is an educational site (something to do with the council of Europe) as opposed to an official standards site, if I'm understanding correctly. > - The basic order of the alphabet 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 > - For the short-long vowel pairs (a á, e é, i í, o ó, ö ő, u ú, ü ű) long = > short usually, but long > short if all else > is equal. E.g., kád < kar < kár < kard So far, this seems to be the opinion of a majority, although not everyone describes the rule the same way. If MySQL adopts this rule, SELECT * FROM t WHERE column1 = 'kár'; will not return rows where column1 = 'kar'. But perhaps SELECT * FROM t WHERE column LIKE 'ká%' will return rows where column1 = 'kar' > - The long double consonants are sorting as if they would have been > expanded. I.e., ggy as gygy, nny as nyny So 'ccs sorts with cscs' is true, i.e. ccs > cds I expect that there is no rule which could apply for all LIKE searches. > - Composit words are sorted according to word parts. I.e., meggyújt < meglát > < megy < meggy > I don't see a way to determine what is a composite word. So MySQL would return meglát < megy < meggy < meggyújt > An alternative collation sometimes used (in libraries, and some dictionaries > and lexica) is according to the basic latin alphabet, whit the accented > letters having the same value as the not accented. Or anything in between. > E.g., honoring the digraphs and the trigraph, but leaving the accents out of > the business. > > I hope this helps. > Yes, and thank you. I'm grateful for the help MySQL is getting on this question. We are still hoping for more responses. > ImRe > > -- Peter Gulutzan, Senior Software Architect MySQL AB, www.mysql.com Office: +1 780 472-6838 Mobile: +1 780 904-0297 VoIP: +1 408 213-6654 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
