How To Check and Change the Collation of MySQL Tables

Understand the importance of configuring collation in databases

Giorgos Myrianthous
Better Programming
Published in
3 min readMar 29, 2021

--

Scrabble pieces
Photo by Sven Brandsma on Unsplash.

Depending on the data that we wish to store in a database, it is common practice to adjust the collation of tables accordingly in order to avoid any unwanted behaviors.

--

--

I strive to build data-intensive systems that are not only functional, but also scalable, cost effective and maintainable over the long term.