In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked.
"Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² On 7/13/14, 3: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:358855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm