fritz-bayer-S0/GAf8tV78@public.gmane.org
2009-Apr-27 07:19 UTC
Encoding Problem / mod_rails / passenger / Postgresql 8.3
Hi, when I use mod_rails/passenger with apache2 on linux instead of webbrick for our application, then it stops working with certain browsers like the ie, and konqueror but still works with firefox. I get the following error message: ActionView::TemplateError (PGError: ERROR: invalid byte sequence for encoding "UTF8": 0xad 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 * FROM "users" WHERE ("users"."login" = E''ë)¢{×M|mÍ{Ó ¿▒Û÷o·œ÷N¹ï¯w×ÞŒ'') AND (users.state = E''active'') LIMIT 1) on line #32 of app/views/layouts/application.html.erb: I think I get the messgae because the login string is not encoded in the char encoding which postgresql expects. The database stores text in utf8. But because the application works without problems with webbrick it seems that this is an mod_rails/apache2 issue? Any ideas what I could do to fix this? Fritz