Command to create MySQL database with Character set UTF-8
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?
Solution 1:
Use the
CHARACTER SET
option when creating your database, like so:
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_bin;
also, read the docs...
Solution 2:
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;"