LAMP programmers often come across MySQL database dumps or existing tables that have wrong collations or where table fields have different collations even within one single table.
Mass Change A Collation for Table Fields in MySQL

Sometimes you feel romantic and want to get something else than phpMyAdmin to communicate to MySQL. Download mysql-workbench-oss-5.2.1-1fc10.src.rpm from one of the mirrors picked up here: