MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<imre Date:October 19 2006 3:02pm
Subject:RE: Hungarian collation
View as plain text  
> From: Peter Gulutzan <peterg@stripped>
> 
> 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


Thread
Hungarian collationPeter Gulutzan17 Oct
  • Re: Hungarian collationPeter Gulutzan31 Jan
RE: Hungarian collationimre19 Oct
RE: Hungarian collationPeter Gulutzan30 Oct
  • RE: Hungarian collationimre31 Oct