ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Special Characters Displaying as � in Entries and Templates

April 17, 2012 5:45pm

Subscribe [2]
  • #1 / Apr 17, 2012 5:45pm

    Eric Barstad

    198 posts

    I’ve just finished upgrading a site from EE 1.6.8 to 1.7.2. Unfortunately, since upgrading, the site is displaying accented characters as �. As far as I can tell, everything is set up for utf-8 character encoding, from the database collation, to EE, to the HTML templates, but for some reason, these characters are still being shown incorrectly even though they look ok in the database.

    According to phpMyAdmin, MySQL connection collation is utf8_general_ci and the database and tables are set that way as well. In the DB, I see the phrase “chèque à la table des inscriptions à la réunion” as is, but on the front end of the site or in the template editor I see “ch�que � la table des inscriptions � la r�union”. It’s the same for entries.

    EE: 1.7.2
    PHP: 5.2.17
    MySQL: 4.1.22
    Apache: ?

  • #2 / Apr 17, 2012 6:39pm

    Eric Barstad

    198 posts

    I was able to solve this problem by making the changes suggested in this post:

    http://ellislab.com/forums/viewreply/540991/

  • #3 / Apr 18, 2012 1:59pm

    Dan Decker

    7338 posts

    Hi Eric,

    As you have discovered, this is related to using UTF-8 for the database. ExpressionEngine 2 requires this, but EE 1 does not.

    I’m glad you were able to get this sorted out for yourself!

    Is there anything else I can assist you with?

    Cheers,

  • #4 / Apr 18, 2012 2:33pm

    Eric Barstad

    198 posts

    Thanks Dan. There’s nothing else.

  • #5 / Apr 19, 2012 3:48pm

    Shane Eckert

    7174 posts

    Hey Eric,

    I am glad that Dan was able to help you out here!

    If you need anything else, please just let us know by opening a new thread.

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases