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:250529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
