CF Error with decrypt

We have a simple application that encrypts credit card numbers in the database and will decrypt via an administration module.

In the admin module in CF4.5, when trying to view a detail of the record, an error occurs stating "The value to be decrypted is not vaild".

In CFMX 6.1 everything works just fine when accessing the record detail.

The attached image shows the database table with the encrypted numbers. All with green arrows have the box as the last character and work fine in CF4.5 and CFMX. The one with the red arrow returns the error in CF4.5. No error in CFMX.

I just don't know if this is a CF4.5 vs. CFMX issue or if there is something else that is wrong. Does it have to do with that box at the end of each record? What other information can I provide to help someone come up with an answer?

thanks!

Not sure what the problem could be, other than the fact that CFMX is much, much more robust than 4.5.

Thanks for your reply, kiteless.

Actually it could be a character encoding issue (that is probably what the box at the end is). It could be that the 4.5 database drivers are barfing on the encoding, but that the 6.1 driver deals with it properly.

As an aside, unless you have hundreds of thousands of dollars to pay people to ensure that your network and database are totally secure, you shouldn't be storing credit card numbers in your database anyway. You have siginificant liability if hackers get to them.