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:

About This Blog

Lorem Ipsum

  © Copyright 2009 Linux-HelpLine.Blogspot.com

Back to TOP