Encoding character set in content.xml

[gers32]

Hi,

I'm developing a Ruby-on-Rails+Flex Web application which generates an ODT file and sends it to the browser.

The data comes from an Oracle database encoded with Windows-1252. Unfortunately, the generated file displays Asian characters in place of the typically French characters in the database (accented vowels, etc). Opening content.xml, I noticed the following encoding information:

<?xml version='1.0' encoding='UTF-8'?>

The source of this encoding information is the ODT template that I created. Assuming this is the cause of my problems, is there a way to generate an ODT template with a different encoding (Windows-1252)?

And maybe this is not the real cause, but someone has a solution... Thanks,

Chris.

[TerryE]

The ODF formants including ODT all use UTF-8. Sorry, but its not practical to change that. The easiest way is to work in UTF-8 and to convert your fields in Oracle from CP-1252 on input and update. I did a google on "1252 utf-8 conversion ruby" and got loads of hits. Why not do likewise and have a browse?

[gers32]

Thank you Terry, your suggestion helped me solve this problem. I was able to convert the data directly in the SQL query, via the 'CONVERT' function.