I see. Just got it changed to be default utf-8. Now it's working :)
On Oct 15, 7:07 am, Christian Hammond <[email protected]> wrote: > Hi Sam, > > This sounds like another instance of the database not being utf-8. We > operate almost entirely in utf-8, and the database needs to be able to store > that. The reviews_review table is the cause for this error, but you'll > likely hit it again and again with more tables unless the entire database is > converted. > > Christian > > -- > Christian Hammond - [email protected] > Review Board -http://www.reviewboard.org > VMware, Inc. -http://www.vmware.com > > > > > > > > On Fri, Oct 14, 2011 at 9:15 AM, Sam <[email protected]> wrote: > > Installing RB for the first time today. I ran into problems when > > trying to comment on code lines using Chines; it would show up as > > question marks after I published it. I made a quick fix by changing > > the text column of a reviews_comment table to be utf8_general_ci > > collation in the database. I noticed that the whole database is mostly > > latin1_swedish_ci collation. > > > Another issue was when trying to submit a review. I turned on DEBUG > > and received an error after pressing submit: > > > Warning at /rb/api/json/reviewrequests/2/reviews/draft/publish/ > > Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column > > 'body_top' at row 1 > > Request Method: POST > > Request URL: > >http://rb.sam.org/rb/api/json/reviewrequests/2/reviews/draft/publish/ > > Exception Type: Warning > > Exception Value: > > Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column > > 'body_top' at row 1 > > Exception Location: /usr/lib64/python2.4/warnings.py in > > warn_explicit, line 96 > > Python Executable: /usr/bin/python > > Python Version: 2.4.3 > > Python Path: ['/var/www/html/rb/conf', '/usr/lib/python2.4/site- > > packages/setuptools-0.6c12dev_r88846-py2.4.egg', '/usr/lib/python2.4/ > > site-packages/python_memcached-1.47-py2.4.egg', '/usr/lib/python2.4/ > > site-packages/MySQL_python-1.2.3-py2.4-linux-x86_64.egg', '/usr/lib/ > > python2.4/site-packages/RBTools-0.3.4-py2.4.egg', '/usr/lib64/ > > python24.zip', '/usr/lib64/python2.4', '/usr/lib64/python2.4/plat- > > linux2', '/usr/lib64/python2.4/lib-tk', '/usr/lib64/python2.4/lib- > > dynload', '/usr/lib64/python2.4/site-packages', '/usr/lib64/python2.4/ > > site-packages/PIL', '/usr/lib64/python2.4/site-packages/gtk-2.0', '/ > > usr/lib/python2.4/site-packages'] > > Server time: Fri, 14 Oct 2011 08:55:38 -0700 > > > Are these known issues? Is there some type of setting or config I need > > to set to make RB more internationalized? > > > -- > > Want to help the Review Board project? Donate today at > >http://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > >http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
