> 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: - 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 - The long double consonants are sorting as if they would have been expanded. I.e., ggy as gygy, nny as nyny - Composit words are sorted according to word parts. I.e., meggyújt < meglát < megy < meggy 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. ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]