Re: cfqueryparam to varchar raw problem

2014-05-22 Thread daniel kessler 

I suspect you have a charset mismatch. What is the DB charset, CF charset
and what is the setting for sending cfqueryparams as Unicode?

Our Oracle 11g displays “AL16UTF16” as the char set.
PERM is UTF-8

However encrypt_column is returning a binary and it's going into a RAW field.  
So should that matter then?

I've done some further experiments that seem to exonerate encrypt_column and 
I'll comment on those below.

~|
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:358678
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfqueryparam to varchar raw problem

2014-05-22 Thread daniel kessler 

I did an experiment, calling ENCRYPT_COLUMN without doing the INSERT.  I ran it 
300 times and it didn't fail once.

cfloop index = x from = 1 to = 300
cfquery  name=qInsertF9099AlienInfo 
datasource=#application.dbDataSource#
  select Encrypt_Column(RPAD(UPPER(NVL(cfqueryparam 
cfsqltype=cf_sql_varchar value=#a_alien_last_name#,' ')),56,' 
'),'CFASJAAAEPTSKEJPI') 
  as my_test
  from dual
/cfquery
cfoutput#x#:/cfoutput cfdump var = #qInsertF9099AlienInfo.my_test#
!--- cfoutputploop = 
#x#:#qInsertF9099AlienInfo.my_test#/p/cfoutput ---
/cfloop

However, I couldn't output the data directly since it's binary (CF said NO!), 
so I did a dump and that was fine.

Since ENCRYPT_COLUMN didn't fail once, I'm led to believe that the problem is 
that the actual INSERT has problems with the data returned or it has problems 
transmitting the returned data properly. 

~|
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:358679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm