Sorry for the late response, I was away on holidays for a bit. We run an in
house content management system for our websites. A user creates/edits a page
which falls under "draft" in our system. The draft is sent to the publisher
who then publishes the page and makes it "live". Our character encoding issues
happen once the text is saved to the database. Once the developer/editor saves
their draft, it gets stored in the DB(we run oracle) and that is where the
character encoding (french text in this case) ends up garbled.
I've checked the default encoding of the oracle db and it's set to ISO-8559-1.
I've also double checked to ensure the coldfusion code isn't causing the issue
when it saves to the database.
Again, any help is appreciated.