Jump to content

Greek language problem in database after import


Prestag0od

Recommended Posts

With a Module I imported data from oscommerce (Latin1) and the Greek entries look like this inside database  "óõììðëçñþíáôá ãéá õíááßêåò". In Backend they dont appeared at all. How can I convert them to look right in the prestashop data base? The data base is UTF-8, the data was in latin1. I tried with Notepad ++ to change to UTF-8 but nothing happens. I also tried to change the collation in the dbase .. again nothing. If I export the imported table and choose ISO 8859-1 and open it in Notepad ++ I can see Greek correctly but when i imported it back the Greek are messed up again.

When I copy-paste them through notepad ++ to phpMyAdmin, (SQL query and run)  are normally imported and show fine! But I can not do this for all the tables when the most have thousands of entries! Any suggestion please?

Edited by Prestan0ob (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...