LKBEN11193: Howto Change mysql collation latin1_swedish_ci into latin1_german1_ci or latin1_german2_ci


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




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.


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!

About the Author

Author: Wim Peeters - Keskon GmbH & Co. KG

Wim Peeters is electronics engineer with an additional master in IT and over 30 years of experience, including time spent in support, development, consulting, training and database administration. Wim has worked with SQL Server since version 6.5. He has developed in C/C++, Java and C# on Windows and Linux. He writes knowledge base articles to solve IT problems and publishes them on the Lubby Knowledge Platform.