mysql»ù´¡½Ì³Ì£ºÈçºÎ´´½¨mysqlÊý¾Ý¿â£¬×î¼òµ¥µÄ´´½¨Êý¾Ý¿âÃüÁî

CREATE DATABASE my_db;

»òÕßÊÇ

CREATE DATABASE IF NOT EXISTS my_db;

´´½¨utf8±àÂëµÄÊý¾Ý¿â

CREATE DATABASE IF NOT EXISTS my_db default character set utf8 COLLATE utf8_general_ci;

ÄÇôÔÚÕâ¸öÊý¾Ý¿âÏ´´½¨µÄËùÓÐÊý¾Ý±íµÄĬÈÏ×Ö·û¼¯¶¼»áÊÇutf8ÁË£¬×¢ÒâºóÃæÕâ¾ä»° "COLLATE utf8_general_ci",´óÖÂÒâ˼ÊÇÔÚÅÅÐòʱ¸ù¾Ýutf8±äÂë¸ñʽÀ´ÅÅÐò

²é¿´Êý¾Ý¿âÁбí

show databases;

ʹÓÃÊý¾Ý¿â

use my_db;

²é¿´Êý¾Ý¿âĬÈϱàÂë

show variables like 'character_set_%'

+--------------------------+-------------------------------------------------------+
| Variable_name            | Value                                                 |
+--------------------------+-------------------------------------------------------+
| character_set_client     | utf8                                                  |
| character_set_connection | utf8                                                  |
| character_set_database   | latin1                                                |
| character_set_filesystem | binary                                                |
| character_set_results    | utf8                                                  |
| character_set_server     | latin1                                                |
| character_set_system     | utf8                                                  |
| character_sets_dir       | /usr/local/mysql-5.5.28-Linux2.6-i686/share/charsets/ |
+--------------------------+-------------------------------------------------------+

¿ÉÒÔ¿´µ½character_set_databaseÊÇlantin1.

ÐÞ¸ÄÊý¾Ý¿â±àÂë

alter database my_db character set latin1;

ɾ³ýÊý¾Ý¿â

drop database my_db;

»òÕßÊÇ

drop database IF EXISTS my_db;