Small encoding problem with French accents

[gotyed]

Any ideas? I still can't figure it out..

[torvista]

The generated html that arrives in the browser says it is 8859 encoded.

The page title text comes out of the database and is utf-8 (change the browser expectations, FFox View-Character encoding to utf8 to show it correctly).

However your product descriptions are 8859 as these go wrong when you change to utf-8.

So the data in your database is in different character sets.

Have you just upgraded to Zen Cart 1.5?

[gotyed]

Hello,

Thank you for your reply.

I'm with 1.3.9h.

If I change my database to 8859, it should solve the problem?

[gotyed]

BTW,

I checked today, and when opening a product, with accents in the product name, it shows without any problem in the title. Just the same "generic" title that is used for all the pages can't be seen correctly.

[torvista]

If I change my database to 8859, it should solve the problem?

It looks as though the text in your database is 8859.

The common title comes from the language file.

Open your french.php or /YOUR_TEMPLATE/french.php if you are using it, with something that can show the encoding like Notepad++ and check the file is encoded as ANSI and not UTF-8.

If it is UTF-8,
copy all,
cut,
change encoding to ANSI,
paste,
save.

[gotyed]

Hi,

Thank you for your answer.

According to the phpMyAdmin, I get the following info - )MySQL connection collation Documentation - utf8_general_ci) and (MySQL charset: UTF-8 Unicode (utf8))



I took the /includes/languages/french.php file and did as you suggested, (it was ANSI as UTF8) converted it to ANSI, but it still doesn't work.

Thanks!

[OopsIbrickedIT]

Hi,

I have little bit similar problem. I transferred an old database from 1.3.7 When using old 1.3.7 it worked fine on new server, after I upgraded to 1.5 and added additonal language pack conatining umlauts it wrecked umlauts.

Db look like it's using table encoding isolatin 1 swedish exept new admin_ tables are UTF-8. When browsing with phpmyadmin data is ok, umlauts & all scandinavian letters showing

so umlauts are like :
À-> should be ä
Both in navigation and body text. Tried several fixes but nothing helps.

I am also using old template from 1.3.7 But I think that's not the problem, Tried default template with same issue. Something in the new 1.5 bricks the char encoding. Perhaps that .htaccess files that are added for security?

So is there any easy(or difficult but bulletproof) fix for this?

I am on a tight schedual, by tomorrow I should be launching the site.

Thanks in advance.

[jobooo]

It looks as though the text in your database is 8859.

The common title comes from the language file.

Open your french.php or /YOUR_TEMPLATE/french.php if you are using it, with something that can show the encoding like Notepad++ and check the file is encoded as ANSI and not UTF-8.

If it is UTF-8,
copy all,
cut,
change encoding to ANSI,
paste,
save.

WORKED FOR ME THANKS!!

Little note: I did not have to copy and save as new file, as the last version of notepad allows to change encoding in the menu.

[Cdclp]

Hello,
I upraded zencart 1.3.9h. to 1.1.5a by myself from this procedure: https://www.zen-cart.com/content.php?148
I had the french language pack installed on my 1.3.9h version. And the box_multi_EZ_pages module.

My site is: h t t p : / / w a - s h i a t s u - n i c e . f r

Here are the php and MySQL versions:
Serveur Hôte: mars.fr.planethoster.net (10.185.0.21) Hôte Base de Données: localhost (127.0.0.1)
OS Serveur: Linux 3.10.0-427.10.1.lve1.4.7.el7.x86_64 Base de Données: MySQL 5.5.5-10.1.18-MariaDB

Serveur HTTP: LiteSpeed
Version PHP: 5.6.27 (Zend: 2.6.0) PHP Limite mémoire: 256M PHP Safe Mode: Off
PHP Uploads de fichiers: On Taille max upload par fichier: 64M Taille max POST: 128M

Since this upgrade everything until now is well. Including the french font with accents in all the website :)).
The site is in UTF-8. And the database also.

I just have the pages uploaded from "tools / define page editor" that can't be correctly loaded:

define_main_page
define_page_2
define_privacy
...

Here is an exemple:
http://wa-shiatsu-nice.fr/index.php?...age=contact_us

The "é" becomes "?" in a black square.

Would you have an idea?

These page are made in UTF-8. They shouldn't have trouble.

Best regards.