Problem not solved
Hi Jason,
You’re right. Keeping utf-8 doesn’t make a problem in this case.
But you get the trouble in the charts, especially the charts related to the products.
When using utf-8 the name “société” is stored like “société” in the database (also when using utf8 as the database and table charset and utf8_unicode_ci as the collation).
Because I need foreign dates (for a French and a German edition) I use mysql_query("SET lc_time_names = 'fr_FR'"); in the Products_Data_Chart1.php to get the French date as “fév 2010” instead of “Feb 2010” (English date). This of course disables the chart build up when you keep <?php echo "<" . "?xml version=\"1.0\" encoding=\"utf-8\" ?".">"; ?><!DOCTYPE wa_dwc SYSTEM "wa_dwc.dtd">. Therefore I have to use ISO-8859-1 in this declaration. But if using ISO-8859-1 here, the name “société” is displayed like “société” in the tooltips a.s.o.
SO I NEED TO USE ISO-8859-1 throughout all pages to store “société” as “société” in the database table Products.
So I need to resolve the character translation (encoding-decoding) in the Products_Result.php to avoid the � when selecting an option or value of a product. To me the problem sticks in the script used to refresh the data in Products_Result.
Please also take note that when using utf-8 in the pages the problem of displaying the product “société” in the receipt email sent to several European email providers and even on 1&1.com (WA recommends !!!!) remains and displays like “société”. If I use ISO-8859-1 in all pages then the problem is solved because “Société” is stored as “Société” in the database field !!!
So please try to replicate this situation using all the infos I gave in my past posts and you will see that using ISO-8859-1 is a MUST for Europeans .
Dani Chankhour solved recently one of my concerns in Products_Detail (in Products_Detail_Lookup) in Powerstore 2. I think he should also look at the present issue, because it’s very similar.
Best regards
Dan