Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Encoding (latin1/ISO-8859-1 vs. UTF-8) conundrum: wiki page

2»

Comments

  • DinoboffDinoboff
    The best thing to do is to convert your database to utf8 (and set CHARSET and DATABASE_CHARACTER_ENCODING to uft-8 and utf8 respectively). However, if you keep CHARSET to ISO-8859-1 (encoding you the page and of your user input), you need to set DATABASE_CHARACTER_ENCODING to the MySql equivalent of ISO-8859-1, Latin1 I think. Vanilla use it to tell Mysql which encoding is sent to it and which is expected.
  • DinoboffDinoboff
    What was the charset used by vanilla 0.9.x?
  • saltesalte ✭
    edited November 2008
    I've set the value to 'ISO-8859-1' on both now, and it's working fine :D

    I was using ISO-8859-1 on my old version as well (0.9.x)

    My only consern now is this - Lussumo Banner (How?) # 14 Hopefully someone can help me with this one as well :)

    Thanks!
  • DinoboffDinoboff
    for CHARSET = ISO-8859-1, DATABASE_CHARACTER_ENCODING need to be set to latin1:
    SET NAMES 'ISO-8859-1'; =>#1115 - Unknown character set: 'ISO-8859-1'
This discussion has been closed.