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.

UTF-8 Spanish characters encoding

November 24, 2009 8:51am

Subscribe [1]
  • #1 / Nov 24, 2009 8:51am

    mediavilla

    79 posts

    Hi there,

    I just launched a new site and I’ve noticed that some characters are not encoded properly… they look OK in the front end but I think that the HTML code is not very SEO friendly…

    I’ve read other threads on the forums about UTF-8 and character encoding but haven’t found a solution to my problem yet.

    I have the HTML meta tag charset set to UTF-8 and the database charset also set to UTF-8 Unicode (utf8). However the fields on the tables have the Collation set to latin1_swedish_ci.

    More info: EE 1.6.8 with MSM 1.1. PHP 5 and MySQL 4.1.25.

    My site is Spanish but I have other sites in English as well so I have to find a solution to change the encoding without affecting all of them…

    Here is an example of what’s going on:

    This text: “Utiliza la guía de referencia rápida”

    Renders HTML: “Utiliza la guía de referencia rápida”

    I’ve checked the record for that entry in the database and the data is stored as it’s rendering so guess I have to change the database or server settings and save/publish this entries again?

    The site is here: http://www.motordeexpresiones.com/

    Any help will be welcome,

    Many Thanks,

    All the best,

    Juan

  • #2 / Nov 24, 2009 9:20am

    Ingmar

    29245 posts

    Your site looks fine. That said, try turning off “Automatically Convert High ASCII Text to Entities”.

  • #3 / Nov 24, 2009 9:33am

    mediavilla

    79 posts

    Hi Ingmar,

    Thanks a lot for the (as always) ultra-fast response…

    That made the trick, I guess that I have to publish my entries again but that’s OK…

    The tables collation set to latin1_swedish_ci should work just fine then?

    Thanks again,

    Best regards,

    Juan

  • #4 / Nov 24, 2009 9:43am

    Ingmar

    29245 posts

    That made the trick, I guess that I have to publish my entries again but that’s OK…

    They should still work, but if you want to replace the entities with properly encoded characters, yes, re-publishing would be the easiest way.

    The tables collation set to latin1_swedish_ci should work just fine then?

    Yes, that shouldn’t be an issue.

  • #5 / Nov 24, 2009 9:49am

    mediavilla

    79 posts

    I don’t want to use properly encoded characters, I just want the content editors to write normally, so for instance the letter “ñ” shouldn’t be encoded as “& ntilde”. I already tried this re-publishing two entries and seems fine…

    Cheers,

    Juan

  • #6 / Nov 24, 2009 9:53am

    Ingmar

    29245 posts

    I don’t want to use properly encoded characters, I just want the content editors to write normally, so for instance the letter “ñ” shouldn’t be encoded as “& ntilde”.

    Yes, I get that, and it’s what I was referring to.

    I already tried this re-publishing two entries and seems fine…

    Yes, it should be.

  • #7 / Nov 24, 2009 9:58am

    mediavilla

    79 posts

    Cool, thank you very much Ingmar, you can close this issue then…

    Kind regards,

    Juan

  • #8 / Nov 24, 2009 9:59am

    Ingmar

    29245 posts

    Glad to hear it. If you need further help, simply start a new thread, please.

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

ExpressionEngine News!

#eecms, #events, #releases