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

Reply via email to