the database in which u are importing from the data should be of same character set as the dump file.