create database in mysql with collation code example

Example: mysql create database utf8

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;