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