MySQL将默认表字符集更改为数据库字符集 [英] Mysql change default table charset to database charset

问题描述

我对mysql表字符集有疑问.我数据库中的每个表都有默认字符集.例如:

I have problem with mysql table charset. Every table in my database has default charset. For example:

CREATE TABLE privacy_settings (
  id_privacy_setting int(11) NOT NULL AUTO_INCREMENT,
  id_account int(11) NOT NULL,
  setting_name varchar(255) NOT NULL DEFAULT '0',
  privacy_level int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_privacy_setting),
  KEY fk_privacy_settings_accounts (id_account),
  CONSTRAINT fk_privacy_settings_accounts FOREIGN KEY (id_account) REFERENCES accounts (id_account) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8  

我想删除DEFAULT CHARSET块，因此表可以使用数据库默认字符集:

I want to remove DEFAULT CHARSET block, so table could use database default charset:

CREATE TABLE privacy_settings (
      id_privacy_setting int(11) NOT NULL AUTO_INCREMENT,
      id_account int(11) NOT NULL,
      setting_name varchar(255) NOT NULL DEFAULT '0',
      privacy_level int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (id_privacy_setting),
      KEY fk_privacy_settings_accounts (id_account),
      CONSTRAINT fk_privacy_settings_accounts FOREIGN KEY (id_account) REFERENCES accounts (id_account) ON DELETE NO ACTION ON UPDATE NO ACTION
    ) ENGINE=InnoDB   

有什么方法可以执行此操作而无需重新创建表吗?

Is there any way to do this without recreating the table?

推荐答案

要更改表的字符集，请从

To change a table's character set, from MySQL Documentation:

如果要将表默认字符集和所有字符列(CHAR，VARCHAR，TEXT)更改为新字符集，请使用如下语句:

If you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

---

如果要将整个数据库转换为使用其他默认字符集，则可以发出以下语句:(来自 查看全文