Is connection property "oracle.jdbc.defaultNChar" supported with supplied Oracle driver in ColdFusion 8?
It seems to be impossible to save unicode encoded strings in nvarchar2 and nchar table fields when database charset (NLS_CHARACTERSET ) is not UTF8 or AL16UTF16. I did manage to save unicode encoded strings in non-unicode Oracle database by creating custom data source in ColdFusion that uses jdbc driver downloaded from Oracle site. All I had to do is add '-Doracle.jdbc.defaultNChar=true' argument to JVM, restart cf. and it worked. Unfortunately, I was not able to find the solution for native Oracle driver. Is there any workaround for this? I am using Coldfusin 8.0.1. with Oracle 10g database. Native Oracle driver informations: Driver Name = Oracle Driver Version = 3.60.26 (023731.010811.016225) Database Name = Oracle Database Version = 10.2.0.1.0 Sorry for my English. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4