This appears to be a UTF-8 encoding issue that may have been caused by a double-UTF8-encoding of the database file contents. My web hosting support has not replied in 48 hours. Could this pose a problem if the MySQL server is latin1?Ĭan MySQL handle the translation of serving content as UTF8 but storing it as latin1? I don't think it can, as UTF8 is a superset of latin1. So, perhaps my database needs to be converted (or deleted and recreated) to UTF-8. I ran an SQL command in PHPMyAdmin to display the character sets: Ã‚ï† buying and renting movies online, downloading software, and UTF-8 was specified as the charset of the import file during the import process. This is the same character set I used in the last import file, which caused more character corruptions. Incidently, I tried running this command in PHPMyAdmin mentioned in this thread, but the problem remains: SET NAMES utf8 If the problem is as simple as specifying the correct language attribute in the database connection string, where/how do I set this, and what to? However, after doing a new search in PHPMyAdmin, I now have about 10 times as many instances of these bad characters in ps_product_lang than I started with. I exported ps_product_lang, replaced all instances of these characters with correct characters, saved the CSV file in UTF-8 format, and reimported them using PHPMyAdmin, specifying UTF-8 as the language. In /config/setting.inc, there is no character encoding string mentioned, just the MySQL Engine, which is set to InnoDB, which matches what I see in PHPMyAdmin. These characters are present in about 40% of the database tables, not just product specific tables like ps_product_lang.Īnother website thread says this same problem occurs when the database connection string uses an incorrect character encoding type. They appear in place of common characters like, - : etc. The front end of the website contains combinations of strange characters inside product text: Ã, Ã, ¢, â‚ etc. I format and import this into Prestashop 1.4.4.
I have a new drop-shipping affiliate website, and receive an exported copy of the product catalog from the wholesaler.