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

Re: non-ASCII in comments

2009-09-15 Thread Christian Hammond
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 mysql's reviews_comment table

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