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