You could maybe use UrlEncodedFormat() after the encypt... This will escape the characters... Its not intuitive, but it should work. You might want to also try another algorithm, but I am not that experienced with encryption.
....................... Ben Nadel www.bennadel.com -----Original Message----- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, August 21, 2006 5:21 PM To: CF-Talk Subject: Encrypted data insert Hey all, I am trying to insert an encrypted string into a MySQL database. When inserted, the db seems to add extra characters on the end of the encrypted string, which makes it so that the string cannot be decrypted successfully. It seems to add a couple of spaces plus the dreaded box character. Is there some sort of encoding issue perhaps? Anyone run into this before? If I use some combination of the encoding and algorithm attributes will it take care of this issue? Yes it's a cc number, and yes I know you're not supposed to store cc numbers, even encrypted, but unfortunately in the real world it must be done sometimes. -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
