Jump to content

latin1_swedish_ci το utf8_unicode_ci


Prestag0od

Recommended Posts

 

I try to import products from a database of another platform that has a Greek but latin1_swedish_ci

Inside the tables the tables are filled with the following characters. (ĂÉÁ-ÂÉÔÁÌÉÍÅÓ )

Is there a way to convert them to import them into the prestashop base correctly?

I changed the collocation of the DBase to UTF-8 as well as the tables but the Greek chars are still like (ĂÉÁ-ÂÉÔÁÌÉÍÅÓ)

Link to comment
Share on other sites

I had similar problems. If you export/import via CSV, you could try to open the CSV file with Notepad or Notepad++ and save it back with the correct character set. The source database may store as latin1_swedish_ci. Does not mean your CSV will be in the same character set. Etc...

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...