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 [EMAIL PROTECTED] -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 8:28 AM To: CF-Talk Subject: Re: Still having problems with encrypt 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
