House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Search cf-talk

July 04, 2009

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Home / Groups / ColdFusion Talk (CF-Talk)

Still having problems with encrypt

Author:
Christine Davis
05/10/2007 11:16 AM

Les, We had a similar problem with both our Java and CF encrypt/decrypt code. We found that our MS-SQL server was being "helpful" and converting, trimming or otherwise manipulating the string we sent in.  We took an additional step and base64 encoded the string before we saved it to the database, and decoded it before we decrypted and everything has been fine ever since.  We were using PBE, so this may not be the answer in your case, but it is something to consider. Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 chdavis@nationsholding.com Ahhh - here's a clue (I hope) - what CHARACTER SET should I have the table cells storing this defined as? (MySQL) I just checked and it's "Latin 1" like the other data, but I don't think that's going to be correct, is it?


Mailing Lists