X
in table T
has these latin1
column values: ORDER BY
with different collations.latin1_swedish_ci | latin1_german1_ci | latin1_german2_ci |
---|---|---|
Muffler | Muffler | Müller |
MX Systems | Müller | Muffler |
Müller | MX Systems | MX Systems |
MySQL | MySQL | MySQL |
ü
), which the Germans call “U-umlaut.”SELECT
using the Swedish/Finnish collating rule, which says that U-umlaut sorts with Y. SELECT
using the German DIN-1 rule, which says that U-umlaut sorts with U. SELECT
using the German DIN-2 rule, which says that U-umlaut sorts with UE.A = Ä
equality, and one has no such equality (latin1_german2_ci
). For that reason, you'll get these results in comparisons: latin1_german1_ci
and utf8_unicode_ci
(the sorting shown is done according to the German DIN 5007 standard).