Mysql - exchange contents from ISO-8859-1 charset column to UTF-8

Question

It is possible to swap the content charset of specific columns?

I have a database with the following architecture: :: Idcontent (int autoincrement) :: Title (vchar) :: Summary (vchar) :: Content (Longtext)

In the form when you registered and/or changed the contents, the columns Title and Summary are with normal accent and the column Content, because it came from a wysiwyg editor configured in ISO-8859-1, is with the accent and special characters changed to this charset pattern.

That way, I wanted to see if:

1. I need to do some routine in PHP that lists and updates via code for all columns to be in ISO-8859-1 or UTF-8 charset; or
2. Is there any internal routine (Alter Table, etc) that performs this adjustment for me.

Thank you.

Answer 1

ALTER TABLE table MODIFY column TEXT [...] CHARACTER SET utf8;