Windows DatabaseebooksStatistical Information

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


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




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.


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-2016 Lubby (V3.0.11 Jan 2016)
Sponsored by Keskon.
Datenschutzerklaerung - Privacy statement - Privacyverklaring