Small encoding problem with French accents

[gotyed]

Hello,

I run my website in English and French.

On the French index page, the title is messed up because of the accents.

All other French content (product descriptions, names etc) are OK.

When changing the meta_tags.php encoding, I can or see the title the way it should be (and the rest is messed up) or just the content and not the title.


Any idea what's wrong?

Thanks!!

[torvista]

wheres the website?

[gotyed]

W w w . P i c s p i c k . C o m

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