Problems with character sets

We currently develop a kind of Portal, like a webtop...all
the
navigation is done through Ajax requests
Initially, all the source files for the project are stored
in a
Subversion repository : the container has an UTF-8 character
set.
Initially our database, Oracle, was positionned to UTF 8 .
Recently , our administrator moved the data to another
Oracle instance
in ISO 8859-15.

When playing the application, all the words with accents are
not well
rendered in our browser.

First, we put a pre filter for all incoming params (sent
through a
form_remote_tag), converting them from utf-8 to iso 8859 15
Our problem now is output.
As Prototype only supports UTF 8, my idea was to convert all
the
source files to ISO (as the database) then create a post
filter to
convert all the content to UTF 8 (as we would do to gzip
output).

Another idea could be to convert all the data to UTF8,
coming from the
database (iso), through find methods from our models, or
custom SQL
queries.
Then , we could do the mix with partials, left in UTF 8 in
the
repository

What could be the best approach? (if you think like me
'leave the
database in UTF8, please don't reply  we
couldn't..this database is
a legacy database, and other older client server application
based on
it need the ISO encoding )

Laurent


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Ruby on Rails" group.
To post to this group, send email to rubyonrailsgooglegroups.com
To unsubscribe from this group, send email to
rubyonrails-unsubscribegooglegroups.com
For more options, visit this group at http://gro
ups.google.com/group/rubyonrails
-~----------~----~----~----~------~----~------~--~---