I have no problem with Chinese, Thai, Japanese, etc, on Heroku's Postgres database. I don't believe I ever did anything special to set this up in Heroku. It just worked.
I did have an error with the mathematical fraction "½", as in Fellini's movie title, but perhaps that can only be represented in UTF16 or perhaps I was using a double-width version of the fraction or some other variation. The fact that I can't see the problematic characters in your message on GMail in Safari on a Mac suggests its the specific characters you're working with that are problematic, rather than Asian characters in general. Stephen On 2 September 2010 17:59, Abel <[email protected]> wrote: > I run into the following error whenever I try to run a rake task in > Heroku: > > rake aborted! > PGError: ERROR: invalid byte sequence for encoding "UTF8": 0xc1c1 > HINT: This error can also happen if the byte sequence does not match > the encoding expected by the server, which is controlled by > "client_encoding". > : SELECT "entries"."id" FROM "entries" WHERE > ("entries".search_id = 53) AND ("entries"."url" = E'http:// > hi.baidu.com/����С��/blog/item/4afdfbfe9b2da33f5c60087a.html') > LIMIT 1 > > The way I interpret it is that PostGres is not configured to read > Asian characters and that this can be configured via the > client_encoding variable, but I don't know where to go from here. > > I'm in the process of finding which method is causing this and similar > errors and applying a begin-rescue block on them, but how do you guys > configure this variable and deal with Asian characters? > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
