Thread

No, I didn’t modify the charset in any way.
It was utf8 from the beginning.

enterweb,

We are still looking into this for you

Please check your email

I have logged into your site. I am afraid something went wrong with the conversion process, there is no way to retrieve the original content. It’s not just a simple encoding error.

When you add new Greek characters to either your entries or templates, they display correctly, so it’s really “just” the database. I understand you have a pre-upgrade backup? What encoding were you using on the old EE site? How large is the dump of your database? I would like to take a look at it myself.

enterweb,

Just making a follow-up here to see how you are getting on. Would you be in a position to come back to us on Ingmar’s questions?

Hello.
I have sent a pm to Ingmar on 28/07 with a url of the sql dump, inorder to donwload and check it.

Regards

Would you mind resending it to him just in case he didn’t get it? Please send it by clicking the MSG button under his avatar. He’s our charset expert.

I got it. For some reason it was buried in Spam, but it’s there. Will take a look and report back in this thread.

OK thank you.

Thanks enterweb, we’ll post back here when we have some more information.

OK, I’ve taken a close lock. The problem, in a nutshell, was this: your database was using a default collation of iso-8859-1 but was exported as utf-8. Which means that utf-8 characters were stored inside Latin-1 fields, creating the mess you’ve seen. This site has much more information on this subject, including a small shell script that converts the characters back to their Greek originals.

I have applied this script to your SQL dump and will send you back the cleaned file. Please let me know if that helps. Please check the converted data carefully, unable to read or write Greek I am in no position to do so. Thanks.

enterweb, please let us know when you’ve had a chance take a look at the converted data. Thanks 😊

Any news? This ticket is still open in our system, any feedback would be much appreciated.

We have no any news yet.
We will inform you as soon as possible.
Thank you.

Very good, looking forward to it.