On 8/7/2014 6:16 AM, Bobby wrote: > > 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?
could be already garbaged as far as cf & unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched & getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm