On Tue, May 20, 2014 at 9:01 PM, daniel kessler wrote: > I am adding CFQueryparams to an INSERT. The item that I am sending over > to the oracle 11g db is empty text. The CFQueryParam is varchar because I > am sending it over as text. > From there, it is encrypted and a Cast_to_RAW is done on it to be put in a > RAW field. This is failing with an "invalid hex number" error. >
I suspect you have a charset mismatch. What is the DB charset, CF charset and what is the setting for sending cfqueryparams as Unicode? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:358673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm