Change the MySQL Collation setting & character set for a DB

Submitted by donmc on Mon, 11/03/2014 - 18:26

Say you want to change the character_set or collation of a MariaDB (MySQL) DB:

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_general_ci;