Anyone else had problems inserting extended ASCII characters into oracle
using either the ODBC or native drivers that come with CF?
When I insert any characters with codes above 160, their codes become the
extended character code minus 128. So for example, if I try to insert
chr(237), e acute, it gets translated to chr(109), 'm'. As far as I can
tell this is not due to the database configuration. The database is
configured to use ISO 88591 and I can insert extended chars into it using
SQL*Plus.
I can work around this by html escaping the data, but I shouldn't need to
and there is a possibility that this data will be used for print in the future.
Thanks
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com