Which collation to use while creating a new MySQL database?

Programming MySQL
1

Hi All,
I’m new to mysql. I’m trying to create a new database for my project. I’m not sure which collation to use. Any help?

2 Likes
2

If you are using cPanel then use phpMyAdmin to create a new database and whatever it shows by default, use that. I use MySQL 8.0 and the default collation for this is utf8mb4_0900_ai_ci. You can visit MySQL :: MySQL 5.7 Reference Manual :: 10.4 Connection Character Sets and Collations to know more about collation.