Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.



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?

share|improve this question
    
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 2:49

1 Answer 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...

share|improve this answer
    
thank you so much –  Komputer Dec 26 '09 at 11:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.