Mind Dump, Tech And Life Blog
written by Ivan Alenko
published under license Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)copy! share!
posted at 21. Apr '18

MySQL/MariaDB create a database

mysql> CREATE database my_love DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Query OK, 1 row affected (0.02 sec)

This will use UTF-8 as a character set and UTF-8 general (language agnostic) case insensitive collation (sorting).

Add Comment