MySQL Database Character Set and Collation
To change MySQL database char set and collation, run
1 |
ALTER DATABASE DB_NAME_HERE CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
To usee current char set and collation, run
1 2 |
USE DB_NAME_HERE; SELECT @@character_set_database, @@collation_database; |
You can specify char set when creating database with following syntax
1 |
CREATE DATABASE DB_NAME_HERE CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |