本文介绍了MySQL将默认表字符集更改为数据库字符集的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我对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;
如果要将整个数据库转换为使用其他默认字符集,则可以发出以下语句:(来自)
ALTER DATABASE db_name DEFAULT CHARACTER SET charset_name;
这篇关于MySQL将默认表字符集更改为数据库字符集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!