Windows DatabaseebooksStatistical Information

LLE10261 : Howto Change mysql collation latin1_swedish_ci into latin1_german1_ci or latin1_german2_ci

Symptom:

You need to change the collation for a certain mysql database from the default latin1_swedish_ci into something different with phpmyadmin

Cause:

none

Solution:

The default collation on mysql is latin1_swedish_ci. When you just installed your debian system, your new databases will have this collation. To change it with phpmyadmin (from the main page) you click on databases, you click on the database (you should click on the name of the database!) you would like to change and then on operations.
Here you go to the end of the page where you can change the collation of the database.

Please note that there is is difference in collation. e.g.

the latin1_german1_ci is not the same as the latin1_german2_ci. These differences are sometimes small but might be important for your application.

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