French characters not displayed correctly in receipt.php

Hello,

I work hard to localize POWERSTORE 2 for French usage (planning to do also a German translation later). All text needs to be adapted ! Nearly all pages are translated now and work fine except for correct display of french accented characters in the emailed RECEIPT.PHP and so forth.

After digging into the database I noticed that french accented characters are stored with "esoteric" symbols in the fields. I changed the standard collation of the fields from latin1_swedish_ci to latin1_general_ci, but the stored French accented characters are still represented with "é" instead of "é". If I change the "é" to "é" directly in the fields in MySQL, the "é" are correctly stored and displayed when I reopen the tables. But if I run POWERSTORE 2 later and update the product containing French accented characters, then the content in the field of MySQL reverts to "é".

I encounter the same problem with the DWC (Dynamic Web Charts) in POWERSTORE 2.

I think that an additional declaration must be added somewhere at the the load of the pages to instruct POWERSTORE 2 to handle correctly French (and later German) accented characters.

Many thanks in advance for any help and suggestions

Have you altered the character encoding that is specified on the pages themselves? If so what values are you using. Also when you are referring to the characters that are stored in the db is this for your products or some other info on the site?

Hello Mr Mittman

I didn't alter the character encoding on the pages itself. The products stored in the db are those entered through POWERSTORE using accented French characters (e.g. société entered in the product name field of POWERSTORE is stored in the db as société.

Altering the collation of the db-field from latin1_swedish_ci to latin1_general_ci permits to correct the é directly in the field of the db (outside POWERSTORE) and is then stored as "société" in the productName field of the db.

Going back to POWERSTORE and using products_detail page, POWERSTORE displays the "é" as white ?-marks on blue squares.

It seems that there is a problem of language between POWERSTORE (aiming US users primarely) and european users.

On the other hand I noticed today another issue in eCart. Altering the numbers (using the latest eCart extension from WA in Dreamweaver) to display as 10.000,00 instead of the US display (10,000.00) does not work (also after having chosen FRENCH as the language).

I'm desperate. Please help me.

Best regards

Dan

I have opened a ticket for you on this issue. To check the status of your ticket or update it please login to WebAssist.com and visit your support history.

In my last post I was curious about the charsets that are being referenced on the page, if you have a better charset to use that is more specific to the language you will be displaying on the pages you should try updating this setting on the pages, it looks like this by default:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

You can find this at the top of the html code on the page below the php code.