close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


French characters not displayed correctly in receipt.php

Thread began 12/15/2009 3:41 am by davas56386677 | Last modified 12/15/2009 9:11 pm by Eric Mittman | 1092 views | 3 replies |


French characters not displayed correctly in receipt.php


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

Sign in to reply to this post

Eric Mittman

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?

Sign in to reply to this post


My answer to your questions

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


Sign in to reply to this post

Eric Mittman

I have opened a ticket for you on this issue. To check the status of your ticket or update it please login to 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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...