MySQL

Create a database with charset utf-8

Posted

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;

or

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;