How to change the encoding of MySQL tables.

The not appropriately selected encoding of database tables can cause annoying problems on a website.

Usually the wrong encoding of the database tables or fields causes this kind of problems.
The best solution, to change the encoding of tables & fields to UTF8.

The easiest way to do this change on database tables, the following;

ALTER TABLE {table} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

This SQL script changes the encoding of the table and all of that fields in the table to UTF8.