I'm trying to import multilanguage database dump. When I try to open this dump with text editor all text in languages other than english display correctly.

I'm trying to import this UTF8 dump into MySQL table. First, I'm creating table:

CREATE TABLE `table` (
....
) CHARACTER SET utf8 ;

Then I import dump into database:

mysql> load data infile 'file.txt'

When I'm viewing database with MySQL Query Browser, international characters looks incorrect. For example, "Аделаида" instead of russian "Àäåëàèäà".

By the way, when I enter data manually using MySQL Query Browser into the MySQL database, everything works fine.

I wonder how can I fix it?