mysql 修改表的字符集

 

修改表的字符集

 

88down voteaccepted

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

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

So query will be:

ALTER TABLE etape_prospection CONVERT TO CHARACTER SET utf8;

posted on 2016-10-31 00:47  alex.shu  阅读(338)  评论(0编辑  收藏  举报

导航