Thanks Ben and Doug, I'll give that a shot. -- Josh
----- Original Message ----- From: "Doug Boude (rhymes with 'loud')" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, August 21, 2006 3:25 PM Subject: Re: Encrypted data insert >I had issues with non printable characters within my encoded strings, so >yes, I concur that you should urlencode the encrypted string before storing >it. Just remember to urldecode it before attempting to decrypt the string. > >>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:250530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
