Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Exporting Database from Latin to UTF8


Mort-lemur

Recommended Posts

Posted

During my 2.3.3.4 install some of the data came over with strange characters on the exported SQL - which were then inported to the new database.

 

When exporting from a database encoded in Latin what format should I use?

 

Below is a screenshot of the problem:

post-253268-0-68884600-1387582742_thumb.png

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

In your store's Admin, go to Tools >> Database Tables. Check all of the boxes, then select Convert to UTF-8 from the pulldown and click Go. That should fix all of your character problems.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Posted

Most likely you have data that was UTF-8, and you forgot to tell phpMyAdmin that the backup was UTF-8 when you imported it. Each byte of the multibyte characters in the file was translated into UTF-8 again. You need to reimport the backup, this time being careful to tell phpMyAdmin that the backup file is UTF-8, so it won't translate it again.

Posted

Thanks Guys,

 

When I look at the sql that I download from the table I am exporting from the characters are there - do I need to export the sql in another format?

 

Many Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

Ok Managed to sort it,

 

When exporting from the old database ensure the export is set to iso-8859-1 then run the sql in the new database and everything is good.

 

Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Posted

@@Mort-lemur

 

Be carefull because the v2.3.3 admin latest version dont save the tables in utf8 standard. There are two possible fixes found, but the best now is to use phpMyadmin for backup.

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Posted

When exporting from the old database ensure the export is set to iso-8859-1

 

Not quite. You can export the old database in UTF-8 (if that's what the data is) and import it into a UTF-8 database, but you have to tell phpMyAdmin (or whatever is doing the importation) what the backup is encoded is (default is Latin-1). If you don't tell it that the backup is UTF-8, it will assume that it has to translate on-the-fly from Latin-1 to UTF-8 during the import. I suspect that's what happened to you.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...