MySQL 5.6

To create database with specific character-set and collate,

Database

character-set= utf8mb4;

collate=utf8mb4_unicode_ci;

To check index,

To get details,

To check character-set,

Reference:

Consistency achieves everything https://github.com/paigekim29