Windows DatabaseebooksStatistical Information

LLE10260 : What is the difference between the mysql collations of latin1_german1_ci and latin1_german2_ci

Symptom:

You need to set a collation but you are not shure what to use for a german database.

Cause:

none

Solution:

The collation of a database is importtant for the sorting of the data.

latin1_german1_ci = DIN-1 (which is found in dictionaries)

latin1_german2_ci = DIN-2 (which is used for address books)

The difference is latin1_german1_ci uses:

� = A
� = O
� = U
� = s

and latin1_german2_ci uses:

� = AE
� = OE
� = UE
� = ss

For many application these differences are not important, but sometimes they are.

Disclaimer:

The information provided in this document is intended for your information only. Lubby makes no claims to the validity of this information. Use of this information is at own risk!
Copyright © 2004-2011 Lubby (V3.0.10 Aug 2011)
Sponsored by Keskon.
Statistical information by Google Analytics