Product import and character encoding problem
 

Well, we have two boards:
- one in ISO-8859-7 (Greek) / my development board
- and another one in UTF-8

When I export a product from my dev board and import it to the UTF-8 board, there is issue with the Greek characters. :(
They appearing as "???????".

In the other hand, if I import the same product on another ISO-8859-7 board works perfect.

Any idea how to fix it?

Is the encoding of the database with the question marks properly set?

hmm yes I think so, but how I can detect that it is the correct encoding?

Both boards I noticed works perfect for posting any characters (english / greek). The issue is on the product import where the greek characters inside the template saved as "?????" cause when I visited the page where a template is called, I see "?????" instead of greek chars.

Any idea? The product I'm trying to import is a bit big, I can't re-build it on the utf-8 board. :(
I need to import it so it will be working as should.

I'm using Notepad++.

Have you tried converting the script using iconv?

https://stackoverflow.com/questions/...19843#36619843

Well, I found a hard-coded solution. :)

1. Open the exported xml with Notepad++
2. Convert it to UTF-8 (Encoding > Encode in UTF-8 > Save)
3. Open file /includes/class_xml.php, then find:
4. Add below:
5. Then try to import *xml product via AdminCP.

All ok! :D

6. Undo step #4.

Done :)