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.

Strange characters

ZiyphrZiyphr New
edited May 2007 in Vanilla 1.0 Help
Everything looks fine when browsing the forum, however when I inspect the database I see some characters (probably produced from Word) such as dashes, quotes, etc, are being saved as


And pound symbols show up as £.

I've written an extension that emails out the contents of a comment and in the email it shows the text as it is in the database.

I'd like to convert these characters in the same way Vanilla does for display but can't see where this takes place in the code.

Any ideas?


  • Options
    I suggest you read Max_B's character encoding page on the lussumo wiki.
  • Options
    I've had a read but I've not seen these weird characters anywhere else. The database was set to latin1_swedish_ci and changing it to utf8 hasn't seemed to make a difference. I've also tried adding: $Configuration['DATABASE_CHARACTER_ENCODING'] = 'utf8'; Even if they're stored in weird mode I'd just like to know how to convert them so it looks normal in an email.
  • Options
    It's on the page, under "Cleaning: MySQL side". Basically what you need to do is do a MySQL dump/database export. Open that up in a text editor which will let you change character encodings (if all you have is notepad, you can download EditPlus or Notepad++) and fiddle around with the data. Full instructions are there in the wiki.
This discussion has been closed.