Command to create MySQL database with Character set UTF-8

Question

I use create database dbname; to create database.
but I want it to created with Character set UTF-8

Anyone know what is the command to use?

note that the database charset is only part of the picture: you have to also set the server and client connection charsets — Javier, Dec 27 '09 at 02:49

score 26 · Answer 1 · answered Dec 26 '09 at 06:06

26

Use the

CHARACTER SET

option when creating your database, like so:

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_bin;

answered Dec 26 '09 at 06:06

LukeR

score 17 · Answer 2 · answered Dec 01 '14 at 21:55

If database name contains nonalphanumeric chars use "`" to quote:

CREATE DATABASE `my-db` CHARACTER SET utf8 COLLATE utf8_general_ci;

When using in shell script quote the quotes with "\"

mysql -p -e "CREATE DATABASE \`my-db\` CHARACTER SET utf8 COLLATE utf8_general_ci;"

2 Answers2