I am facing problem while translating text, I have two stores views, English and French. On French store view the text is translated with special characters. ex:

Qty = Qté
Recently added item(s) = Derniers articles ajoutés.

It need to display "Qté" and "Derniers articles ajoutés" respectively. I have added all the translation words in:


But no success. I don't want to translate this with inline translation functionality.

Why is this happening any idea?

1 Answer 1


This is the utf-8 encoding problem !

You have wrong encoding either in your IDE, database or in documents translation files. Ensure that the encoding is utf-8 in :

IDE while editing: choose the utf-8 encoding

Database: -> app/etc/local.xml <initStatements><![CDATA[SET NAMES utf8]]></initStatements>or <charset>utf8</charset>

Database should looks like:

                <initStatements><![CDATA[SET NAMES utf8]]></initStatements> //<---
                <charset>utf8</charset> //<---
  • I changed my sublime text IDE to with UTF-8 encoding and saved my files again. but no use its still showing same characters. Is there any other settings related Magento db?
    – Charlie
    Commented Mar 26, 2017 at 3:43
  • Look my updates please
    – PЯINCƎ
    Commented Mar 26, 2017 at 8:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.