mysqldump / utf8

[Hans Scholte]

hi,

I have some trouble dumping and re-importing my sql database and data.
I load data with a Perl script into a MySQL database. When quering the data everything looks fine. When dumping the data with mysqldump some chars are garbled. I googled quit a bit, tried a lot of thing but with no luck. Hope anybodye here could help me out.

Some info:
MySQL version: 5.0.95
I created the database script with MySQL Workbench 6.3, default collation latin1, tables utf8 (I also tried both utf8).
After loading the database en querying a title it looked ok
After dumping and re-importing it on another system the data was corrupted.
The letter 'ü' came out as (hex) C3BC and was not shown properly.
C3BC is binary 11000011 10111100 -> 2 bytes of utf8 -> gives [110]00011[10]111100 -> FC = 'ü'

What is going on here? And what am i doing wrong?

Regards,
Hans Scholte