Data migration tool 2.1 - encoding character unicode

[Onthera]

Hello,

I have an issue with migration. I almost succesfully migrate data from Magento 1.8.1.0 to magento 2.1.

I have database on same server.

But when I migrate data, it destroy unicode encoding. Both database have same encoding, „utf8_unicode_ci“, tables too.

But characters like ěščřž are replaced by question mark. I know, that this is the problem with encoding, but i cant find out where. Is there any possibility to set encoding for migration? Or where could be a problem?

Any help, hints?

Thank you very much

BTW. Data migration tool bug. If you have M2 database with prefix, migration stuck on PostProcessing Integrity check, because it looking for table without the prefix.

[UberTheme]

I am not sure which migration tool did you use.

In general, when you create your new M2 db, you need to set your db/tables with Collation as follows: 

Collation: utf8_general_ci

There might be exception for other migration tools. Yet the above note will help to avoid unicode encoding issue when using our migration tool.

[UberTheme]

Just found this post, a good ref about the collation mentioned above. 

https://forums.mysql.com/read.php?103,187048,188748

[Onthera · Accepted solution]

Guys, thank you for you help.

Already solve it. Problem is not on my side like database encoding. All was set to UTF8 collation.

But this help. Migration tool problem...

https://github.com/magento/data-migration-tool/pull/28

Unfortunately still not merged into master. But never mind.

Thanks and have a nice day