MySQL - CREATE DATABASE

CREATE DATABASE [IF NOT EXISTS] mydb CHARACTER SET utf8 COLLATE utf8_danish_ci

The IF NOT EXISTS clause can be useful in applications that needs to ensure that a given database is available, without disrupting any existing database with the same name.

The CREATE DATABASE statement has two optional clauses, CHARACTER SET and COLLATE. These settings are stored in db.opt in the database directory.