Encoding Problem / mod_rails / passenger / Postgresql 8.3


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
: 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?


This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs