July 21, 2005 at 12:38 pm
Hello all,
Anyone has any idea how to encrypt and decrypt credit card number .
I tried to use XP_crypt with sql server2000.
but it does't work.
Please help.
Thanks
July 21, 2005 at 12:49 pm
Can you give us the error message and an example of how you're using it (please make sure to use dummy data)?
K. Brian Kelley
@kbriankelley
August 1, 2005 at 9:09 am
I use XP_Crypt all the time without difficulty. Of course, I have a licensed copy.
Is your copy licensed? Consider: An unlicensed copy XP_Crypt only encodes up to 15 characters. Credit card numbers for MasterCard and Visa are 16 digits. AMEX is 15. If you are evalutating XP_Crypt, MC and Visa account numbers will not decode completely from an encoded string.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply