Re: non-ASCII in comments

2009-09-15 Thread Dmitry Konyshev
Hi, David and Christian, Thank you for the prompt responses and the tip! I'm running MySQL 5.0.84. This command did the trick: ALTER TABLE reviews_comment MODIFY text longtext CHARACTER SET utf8; I guess, now I need to find other longtext columns in the database and convert they too? I reall

Re: non-ASCII in comments

2009-09-15 Thread Christian Hammond
Hi Dmitry, Review Board is designed to work entirely with UTF-8, but it's up to the database to use the correct encoding. It's possible that yours isn't set for UTF-8. When did you create your database, and what version of MySQL are you using? You should be able to see the character set of the c

Re: non-ASCII in comments

2009-09-15 Thread David Trowbridge
It sounds like maybe the tables aren't UTF-8. I don't recall off the top of my head how to change the charset of your tables, but I recall the mysql documentation on the topic being relatively helpful. -David On Mon, Sep 14, 2009 at 11:58 PM, Dmitry Konyshev wrote: > > Hi guys, > > First of a

non-ASCII in comments

2009-09-15 Thread Dmitry Konyshev
Hi guys, First of all, many thanks to the developers of this wonderful piece of software! Please help me with the following issue: When I use non-ASCII characters in comments (specifically, cyrillic characters), they are turned into question marks once comments are published. I looked at the my