Are you using the oracle to_nchar() function? http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions187.htm#i1006719
I don't recall what the resulting symptoms are, but I recall having to use that to insert multi-byte characters in Oracle. On Sun, Jul 13, 2014 at 12:26 AM, Sathyanarayanan Ramanathan <sathya0...@gmail.com> wrote: > > Dear All, > > I am trying to insert Arabic text into my ColdFusion application with > Oracle database. > I tried below 3 scenarios but didn't work for me. > > 1. One of my ColdFusion application is already implemented to handle Arabic > text using Oracle db. > I checked the NLS_characterset & is set to AR8MSWIN1256. There are few > Arabic text found in few tables. > But when I try to insert some sample rows with arabic text using toad it's > coming as ?????. > > 2. I created a new database and tried to set NLS_characterset to > AR8MSWIN1256. > I tried to create a table & insert some sample rows with Arabic text using > toad it's still coming as ?????. > > 3. I searched few sites & set NLS_characterset to AL32UTF8. But still the > results are same. > > Your time & help will be really appreciated. > > Sathya.R > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm