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 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
