He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type?
On 8/6/14, 12:21 PM, "Paul Hastings" <p...@sustainablegis.com> wrote: > >On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote: >> *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data >>in >> some table columns. But when I try to fetch & display using CF even >>after >> adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic >>text >> appeared as ????. > >"??" means your text data is garbaged from the db. double check that it's >stored >in an "N" datatype (nchar, nvarchar, etc.). then double check if the data >is in >fact encoded as unicode. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm