MySQL數(shù)據(jù)庫的db.opt文件

MySQL的每個數(shù)據(jù)庫目錄中有一個文件db.opt,該文件主要 用來存儲當前數(shù)據(jù)庫的默認字符集和字符校驗規(guī)則。

eg.default-character-set=latin1
default-collation=latin1_swedish_ci

該文件中存儲的是創(chuàng)建數(shù)據(jù)庫時默認的字符集和字符集校驗規(guī)則，則該數(shù)據(jù)庫在以后創(chuàng)建表時如果沒有指定字符集和校驗規(guī)則，則該表的這兩個屬性將去自這兩個表。

MySQL源碼：

/* Set table default charset, if not set
SYNOPSIS
set_table_default_charset()
create_info Table create information
DESCRIPTION
If the table character set was not given explicitely,
let’s fetch the database default character set and
apply it to the table. */
static void set_table_default_charset(THD *thd,
HA_CREATE_INFO *create_info, char *db)
{
if (!create_info->default_table_charset)
{
HA_CREATE_INFO db_info;
load_db_opt_by_name(thd, db, &db_info);
create_info->default_table_charset= db_info.default_table_charset;
}
創(chuàng)建數(shù)據(jù)庫時指定字符集和字符集校驗規(guī)則：
create database if not exists test default [charset|character set ] utf8 default collate utf8_general_ci;
修改數(shù)據(jù)庫的字符集和字符集校驗規(guī)則：
alter database test default [charset|character set ] latin1 default collate latin1_swedish_ci;
創(chuàng)建數(shù)據(jù)庫create database
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[create_specification] …
create_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
也可以通過alter database修改
ALTER {DATABASE | SCHEMA} [db_name]
alter_specification …
alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name

MySQL源碼：

/* Set table default charset, if not set
SYNOPSIS
set_table_default_charset()
create_info Table create information
DESCRIPTION
If the table character set was not given explicitely,
let’s fetch the database default character set and
apply it to the table. */
static void set_table_default_charset(THD *thd,
HA_CREATE_INFO *create_info, char *db)
{
if (!create_info->default_table_charset)
{
HA_CREATE_INFO db_info;
load_db_opt_by_name(thd, db, &db_info);
create_info->default_table_charset= db_info.default_table_charset;
}
創(chuàng)建數(shù)據(jù)庫時指定字符集和字符集校驗規(guī)則：
create database if not exists test default [charset|character set ] utf8 default collate utf8_general_ci;
修改數(shù)據(jù)庫的字符集和字符集校驗規(guī)則：
alter database test default [charset|character set ] latin1 default collate latin1_swedish_ci;
創(chuàng)建數(shù)據(jù)庫create database
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[create_specification] …
create_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
也可以通過alter database修改
ALTER {DATABASE | SCHEMA} [db_name]
alter_specification …
alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]