How to change the default charset of a MySQL table ?
Monday, February 27, 2017
How to change the default charset of a MySQL table ?
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 employee CONVERT TO CHARACTER SET utf8;
0 comments:
Post a Comment