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.
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.