Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.
    •  
      CommentAuthoralkar
    • CommentTimeFeb 15th 2008 edited
     # 1
    Well, I got the latest Vanilla release installed everything and added addons and it's sweet. Yet, I got on problem. When I tried posting some comments in Greek (which will be the language used in it) the characters appear as question marks. I tried changing encoding on the browser and where I found relevant settings in the configuration files, but no luck.

    It seems as if they get converted to question marks upon posting a comment and I got no clue as to why.

    I would appreciate some help here.

    PS.: I will be using the default English interface, this has to do with discussions only.

    EDIT: I found out by messing with mySQL (I had a hunch) that vanilla's tables get a latin1_swedish_ci encoding. On the other side, phpbb uses utf8_bin and joomla uses utf8_general_ci. Changing the encoding of the Body field in the LUM_Comment table to the latter encoding and reposting the comment worked. Any ideas why it would be so? I guess it would be fine if I changed the encoding of the whole db?
  1.  # 2
    There is some pretty wholesome documentation about character encoding in the wiki. that should answer any questions you have.
    •  
      CommentAuthoralkar
    • CommentTimeFeb 15th 2008
     # 3
    Just read that. Pretty much what I did to fix it. Though I didn't know about the configuration setting.

    You can also just export the existing database, delete those default charset fields and re-import it with phpMyAdmin (instead of creating a whole new table).

    Thanks again :)
Add your comments
    Username Password
  • Format comments as