I see. Just got it changed to be default utf-8. Now it's working :)


On Oct 15, 7:07 am, Christian Hammond <chip...@chipx86.com> 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 - chip...@chipx86.com
> Review Board -http://www.reviewboard.org
> VMware, Inc. -http://www.vmware.com
>
>
>
>
>
>
>
> On Fri, Oct 14, 2011 at 9:15 AM, Sam <sam...@gmail.com> 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
> > reviewboard+unsubscr...@googlegroups.com
> > 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 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en

Reply via email to