What follows is a collection of links that deal with common character set issues in MySQL setups.
This short article desribes how to find out the current encoding settings of a MySQL database.
This is the official documentation of character set manipulation in MySQL 5.5.
This article describes in detail how characters are represented in the database. Basically, it introduces how character encodings work.