Understand Character Sets and Collations in MySQL

Learn basic concepts and how to specify character sets and collations at various levels in MySQL

Lynn G. Kwong
Level Up Coding
Published in
6 min readApr 1, 2024

--

Image by Mohamed_hassan on Pixabay

In this post, we will introduce the basic concepts of character sets and collations in MySQL and how to specify them at various levels for different scenarios. In most cases, using the default character set utf8mb4 and…

--

--

I’m a Software Developer (https://medium.com/@lynn-kwong) keen on sharing thoughts, tutorials, and solutions for the best practice of software development.