mysql collation issues

Whenever I forgot to to change the collation of my newly created database I started getting angry... When I am angry I usually sigh a lot. But that's not the point of this post.

The point is, if it's too late to recreate the database and all its tables, you will have to change a collation for:

• database itself
• all the tables inside this database
• all the fields in all the tables

Developers are usually not aware of the third one. And that really sucks balls.