always create new db with utf8 character set

why doesn’t mysql create db with utf8 character set by default?

It should.

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

Author: bpeh

Bernard Peh is a great passioner of web technologies and one of the co-founder of Sitecritic.net Website Design and Reviews. He works with experienced web designers and developers everyday, developing and designing commercial websites. He specialises mainly in SEO and PHP programming.