Re: non-ASCII in comments
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 really wish "rb-site install" did this for me :) Regards, Dmitry On Tue, 15 Sep 2009 00:13:30 -0700 Christian Hammond wrote: > 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 columns using: > > SHOW FULL COLUMNS FROM reviews_review; > > Look at the collation column. If you see anything other than utf8 > for, say, body_top, then you'll need to convert the database. > > This article may be useful for figuring out how to convert to UTF-8. > > > http://kb.mediatemple.net/questions/138/Default+MySQL+character+set+and+collation > > Christian > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "reviewboard" group. To post to this group, send email to reviewboard@googlegroups.com To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -~--~~~~--~~--~--~---
Re: non-ASCII in comments
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 columns using: SHOW FULL COLUMNS FROM reviews_review; Look at the collation column. If you see anything other than utf8 for, say, body_top, then you'll need to convert the database. This article may be useful for figuring out how to convert to UTF-8. http://kb.mediatemple.net/questions/138/Default+MySQL+character+set+and+collation Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.review-board.org VMware, Inc. - http://www.vmware.com On Mon, Sep 14, 2009 at 11:58 PM, Dmitry Konyshev wrote: > > 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 mysql's reviews_comment table and found > that the characters are broken in the table also. > > How can this be fixed? > > Regards, > Dmitry > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "reviewboard" group. To post to this group, send email to reviewboard@googlegroups.com To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -~--~~~~--~~--~--~---
Re: non-ASCII in comments
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 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 mysql's reviews_comment table and found > that the characters are broken in the table also. > > How can this be fixed? > > Regards, > Dmitry > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "reviewboard" group. To post to this group, send email to reviewboard@googlegroups.com To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -~--~~~~--~~--~--~---
non-ASCII in comments
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 mysql's reviews_comment table and found that the characters are broken in the table also. How can this be fixed? Regards, Dmitry --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "reviewboard" group. To post to this group, send email to reviewboard@googlegroups.com To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -~--~~~~--~~--~--~---