French translation and special characters

[Jatt]

I installed the French add-on on my zen-cart.

However, the special characters are changed for some weird code...

à for à
é for é
ô for ô
è for è
etc...

That's fine for the web site as the code is changed for the real character.

However in the emails sent to the French customers, the code is shown instead of the character.

Here is an example:
Nous vous remercions de votre confiance !
Voici les détails de votre commande.
------------------------------------------------------
Numéro de commande : 1
Date de commande : vendredi 06 août 2010 Facture détaillée :


How can I change that so the emails look good and are readable.

[Jatt]

I tried to find a solution on my own and I'm stuck...

I tried the solution suggested in another post, saying to create a my_db_charset.php file in the extra_configures folders (catalog/include and admin/include)
didn't do it.

I changed the create_account.php file in the catalog/includes/languages/french folder and replaced the following word:
détails for détails

Before the change, the email showed: détails both in text and html
After the change, the email shows: détails both in text and html.
What can I do to make it show détails so the customer receives a readable welcoming email

[ink]

Kind people Dr Byte / Ajeh is there a solution to this? We too have the same problem, the store/database is set to UTF-8, or are we missing something simple?

[ink]

Maybe this only? http://www.srw2d.com/sites/default/f...cartV1.3.8.pdf

[mehamgul101]

well maybe you can find the soloution by sending them an email to the help centre if it is still creat problem for you
then definitely they will solve your french translation problem or go to the link as the above user has provided ........

[abcisme]

Still searching for a solution to this issue. My French language characters are showing up as é etc. in my text emails. If I put the actual "é" nothing shows in the text email.

I searched the developers toolkit for iso-8859-1 and changed everything to utf-8. I can't figure out how to make this work. Extremely frustrating.

If anyone has found a way to make this work, please be so kind as to let us all know! Thanks!

[abcisme]

Very close to figuring this out, but not 100%.

In includes / functions / functions_email.php

Find:

/ / Fix slashes 
$text = stripslashes ($email_text);

Replace with:

      // fix slashes
      $text = stripslashes (utf8_encode(html_entity_decode($email_text)));

The only problem now is that the accents in the order status and the order status comments have iso-8859-1 codes showing up.

For example:

Commentaires :
Annulé

L'état de votre commande a été mis à jour : Annulé

Not sure where to go about mending that....

[abcisme]

Ok, I realize this is NOT the right way to go about fixing it, but here's what I did to make the text emails work right until someone comes up with the correct solution:

Find:

/ / Fix slashes 
$text = stripslashes ($email_text);

Replace with:

      // fix slashes
      $text = stripslashes (utf8_encode(html_entity_decode($email_text)));

Find:

     // fix double quotes
      while (strstr($email_text, '"')) $email_text = str_replace('"', '"', $email_text);

Add after:

	  //fix special french characters
while (strstr($email_text, 'À')) $email_text = str_replace('À', 'À', $email_text);
while (strstr($email_text, 'â')) $email_text = str_replace('â', 'â', $email_text);
while (strstr($email_text, 'Â')) $email_text = str_replace('Â', 'Â', $email_text);
while (strstr($email_text, 'ä')) $email_text = str_replace('ä', 'ä', $email_text);
while (strstr($email_text, 'Ä')) $email_text = str_replace('Ä', 'Ä', $email_text);
while (strstr($email_text, 'æ')) $email_text = str_replace('æ', 'æ', $email_text);
while (strstr($email_text, 'Æ')) $email_text = str_replace('Æ', 'Æ', $email_text);
while (strstr($email_text, 'ç')) $email_text = str_replace('ç', 'ç', $email_text);
while (strstr($email_text, 'Ç')) $email_text = str_replace('Ç', 'Ç', $email_text);
while (strstr($email_text, 'é')) $email_text = str_replace('é', 'é', $email_text);
while (strstr($email_text, 'É')) $email_text = str_replace('É', 'É', $email_text);
while (strstr($email_text, 'è')) $email_text = str_replace('è', 'è', $email_text);
while (strstr($email_text, 'È')) $email_text = str_replace('È', 'È', $email_text);
while (strstr($email_text, 'ê')) $email_text = str_replace('ê', 'ê', $email_text);
while (strstr($email_text, 'Ê')) $email_text = str_replace('Ê', 'Ê', $email_text);
while (strstr($email_text, 'ë')) $email_text = str_replace('ë', 'ë', $email_text);
while (strstr($email_text, 'Ë')) $email_text = str_replace('Ë', 'Ë', $email_text);
while (strstr($email_text, 'î')) $email_text = str_replace('î', 'î', $email_text);
while (strstr($email_text, 'ÃŽ')) $email_text = str_replace('ÃŽ', 'Î', $email_text);
while (strstr($email_text, 'ï')) $email_text = str_replace('ï', 'ï', $email_text);
while (strstr($email_text, 'Ã� ')) $email_text = str_replace('Ã�� �', 'Ï', $email_text);
while (strstr($email_text, 'ô')) $email_text = str_replace('ô', 'ô', $email_text);
while (strstr($email_text, 'Ô')) $email_text = str_replace('Ô', 'Ô', $email_text);
while (strstr($email_text, 'ù')) $email_text = str_replace('ù', 'ù', $email_text);
while (strstr($email_text, 'Ù')) $email_text = str_replace('Ù', 'Ù', $email_text);
while (strstr($email_text, 'û')) $email_text = str_replace('û', 'û', $email_text);
while (strstr($email_text, 'Û')) $email_text = str_replace('Û', 'Û', $email_text);
while (strstr($email_text, 'ü')) $email_text = str_replace('ü', 'ü', $email_text);
while (strstr($email_text, 'Ãœ')) $email_text = str_replace('Ãœ', 'Ü', $email_text);
while (strstr($email_text, '«')) $email_text = str_replace('«', '«', $email_text);
while (strstr($email_text, '»')) $email_text = str_replace('»', '»', $email_text);
while (strstr($email_text, 'Ã')) $email_text = str_replace('Ã', 'à', $email_text);

[torvista]

You are making matters worse trying to fix something that is not broken.

The need for correct accents everywhere is the same in spanish: install a fresh zen cart 1.51 and the corresponding spanish language pack. Check that it works fine, then add the french one, see if it works. Compare them to see what is going wrong.

[abcisme]

I'm using 1.3.9h and have a ton of mods. There's no way I can do a fresh install and start over.

This is not something that is just my installation. It's documented on Zen Cart France also: http://www.zencart-france.com/forum/...l-t3455.0.html

I'm sure it has something to do with the fact that the French language pack was in ISO-8859-1, which I switched to UTF-8.

Like I said, I know what I did was not the right way to fix it, but it is working for now. So until I can figure out what the proper solution is, that's going to have to be the bandaid.

One solution is to use 2 differents datas in the language definition file (one for email, one for the site).

I think this would work, if I knew how to do it. If I could set the email charset to iso-8859-1 and the site email to utf-8, then I could just use html_entity_decode to decode the text email....? Maybe?