LKBEN11193: Howto Change mysql collation latin1_swedish_ci into latin1_german1_ci or latin1_german2_ci


This article has not been checked!

LKB | Created: 02/04/2020 | Version: 0 | Language: EN | Rating: 0 | Outdated: False | Marked for deletion: False

Author: Wim Peeters - Keskon GmbH & Co. KG


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.

About the Author

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 in different European countries and different European languages. He writes knowledge base articles to solve IT problems and publishes them on the Lubby Knowledge Platform where he is one of the most important contributors and the main developer.

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!