Home » MySQL » Converting MySQL tables to UTF-8

Quick and easy code to convert the character set of a MySQL table to UTF-8. Of course this works for all character sets not just UTF

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Tags: , , ,

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>