I am trying to import products using Magmi.
Some of the products include special characters, such as é, à, etc.
When I import the products, I get the following error for the items that have the special characters:
SKU [the product's sku] SQLSTATE[HY000]: General error: 1366 Incorrect string value: '[character code]' for column 'value' at row [column # I use for the product name]
So far I have tried:
- Encodings: UTF-8 and Latin1 when I export to csv
- Change the special characters to Latin1 values
I keep getting the same error, whatever I try to change.
Please help me :)