CODE EXAMPLE FOR SQL

mysql create database with collation

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;