Our development environment was just upgraded from Oracle 10G to Oracle
11G (which is not officially supported by ColdFusion, but it's not our
decision). We're on ColdFusion 7 Enterprise and we're using the supplied
Data Direct drivers. We are getting some unexpected non-standard special
characters spread through our output that is pulled from Oracle 11G
CLOBs\BLOBs that we were not getting with Oracle 10G.
If we run this query:
Select value from SYS.NLS_DATABASE_PARAMETERS where PARAMETER =
'NLS_CHARACTERSET'
to determine the character sets that are being used by Oracle we find:
Oracle 10G - US7ASCII
Oracle 11G - UTF8
We are accepting the ColdFusion 7 default use of UTF-8 in our
application and we do not override it anywhere in our application.
Any ideas why we wouldn't get non-standard characters in our output with
Oracle 10G set up to use US7ASCII but we DO get these non-standard
characters with Oracle 11G set up to use UTF-8?
Thanks!
George
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320104
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
