Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

data-migration-tool converts utf8 characters to ? #96

Closed
kandrejevs opened this issue Jun 17, 2016 · 6 comments
Closed

data-migration-tool converts utf8 characters to ? #96

kandrejevs opened this issue Jun 17, 2016 · 6 comments

Comments

@kandrejevs
Copy link

kandrejevs commented Jun 17, 2016

when migrating data from magento 1 to magento 2, some utf characters are converted to ?

example:

can't view orders because when migrating data from sales_flat_order_item to sales_order_item table, product_options column contains serialized data. In my case product name contains character č, after migration s:34:"Nohavičky HP25 ružovočierna S/M" becomes s:34:"Nohavi?ky HP25 ružovo?ierna S/M" since č is 2 bytes long and ? is only 1 byte, string is no longer 34 bytes long and unserialize function returns false and throws notice, which cause fatal error, because product options can't be unserialized.

@victor-v-rad
Copy link
Collaborator

Hi @kandrejevs
Try this fix #28

@kandrejevs
Copy link
Author

Unfortunately, it did not help. value migrated from customer_entity_varchar to customer_entity loose double byte character and ? is present.

@victor-v-rad
Copy link
Collaborator

An internal issue was created MAGETWO-54492

@Polar77
Copy link

Polar77 commented Jul 7, 2016

Data-Migration-Tool does not receive data from the source in utf8.
Here is a simple solution to this problem

@ilol
Copy link

ilol commented Jul 7, 2016

Thank you, @Polar77

@victor-v-rad
Copy link
Collaborator

The bug was fixed in the recent release. Please try it out. Feel free to reopen the issue if it is still relevant.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants