In the years before MySQL 4.1, the first MySQL version which provided a complete and good support to different character encodings, developers who needed their databases to store UTF8 encoded data used different encodings (usually latin1) for table and databases while still storing real UTF8 data inside.

While the DB and tables were, as an example latin1 encoded, inside there were actually UTF8 encoded data.