cancel
Showing results for 
Search instead for 
Did you mean: 

Data migration tool 2.1 - encoding character unicode

SOLVED

Data migration tool 2.1 - encoding character unicode

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Data migration tool 2.1 - encoding character unicode

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

View solution in original post

3 REPLIES 3

Re: Data migration tool 2.1 - encoding character unicode

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.

 

--
We have been building for Magento since 2009. See our growing Magento 2 Extensions & Themes collection.

Re: Data migration tool 2.1 - encoding character unicode

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

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

--
We have been building for Magento since 2009. See our growing Magento 2 Extensions & Themes collection.

Re: Data migration tool 2.1 - encoding character unicode

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