Credit Card Number length of field

[Ap.Muthu]

The customer credit card number field is 255 varchar.
Can we reduce it to 19 as in:
http://www.ubercart.org/forum/support/6139/credit_card_maximum_length
or do we retain it as it is to accomodate multiple credit card numbers and
then render the field not usable in payment gateways?

Regards,
Ap.Muthu

[Justin Kelly]

thanks ap - last time i check the code in this area the credit card number gets encrypted before saving into the db

- so not saving raw credit card numbers

- so no idea what the max/min would be 

- best to keep as is

cheers

justin

[Ap.Muthu]

The length of the encryption is the same as that of the credit card number - 19 max should be okay, 20 varchar acceptable - if only one is on record and needs to be usable. It is a substitution / rotation (scramble) based encryption done in library/encryption.php

 

No Luhn check is done on the credit card number.

 

https://github.com/apmuthu/phpprojects/blob/master/phpLuhn.php

 

----- Original Message -----

From: Justin Kelly

To: Ap.Muthu

Cc: SI Group

Sent: Monday, November 11, 2013 5:35 AM

Subject: Re: Credit Card Number length of field

thanks ap - last time i check the code in this area the credit card number gets encrypted before saving into the db

- so not saving raw credit card numbers

- so no idea what the max/min would be 

- best to keep as is

cheers

justin

[Justin Kelly]

ok ap - if you want reduce it down to 20 character limit

cheers

justin

[Ap.Muthu]

Done

zip_code, credit_card_number field size to VARCHAR(20)

Ref: https://groups.google.com/forum/#!topic/simpleinvoices/D7lhYgyEN6s

https://github.com/simpleinvoices/simpleinvoices/commit/d3b027b0adada1765ec5b3837e8649119eb61229

 

----- Original Message -----

From: Justin Kelly

Cc: SI Group

Sent: Monday, November 11, 2013 10:38 AM

Subject: Re: Credit Card Number length of field

ok ap - if you want reduce it down to 20 character limit

cheers

justin