database - How do I change a MySQL table to UTF-8?

Question

I know there are many settings for a language for a table and a database.

I already created the database. I believe when I created it, it was default/LATIN. I want to change everything-I mean...both the table and the database, to UTF-8.

How can I do that? thanks.

Answer 1

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;