UTF8, problem when importing dump

[alexey9]

Hello guys,

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?

[alexey9]

Still can't find the solution. Any ideas?

[eelixduppy]

Solution found here: [webmasterworld.com...]

[alexey9]

No, it's another problem with another data here.

Here I'm trying to import UTF-8 database dump (text file in UTF-8 with data) into MySQL table in UTF-8. But I get corrupted data even in MySQL Query Browser.