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

Powerstore 3: nice � intsead of "é" when using accordion sidebar !

Thread began 2/19/2010 8:03 am by davas56386677 | Last modified 2/19/2010 4:50 pm by davas56386677 | 1267 views | 5 replies


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 &#65533; 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& (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

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...