MySQL create UTF database

The one command that I use very often and I always forget exactly how it was.  So here is how one creates UTF8 database in MySQL:

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
Reference
http://dev.mysql.com/doc/refman/5.0/en/create-database.html

Popular Posts