NewEcommerce1 Posted March 7, 2012 Share Posted March 7, 2012 Using PHP 5.3.6 MySQl 5.5.9 MAMP (for development) When the last four digits of a credit card number have 0's - because the cc_num is stored as an integer, those zero's are not stored. In my test account, with Authorize, the test card number's last four digits are 0027. This is stored in the orders table as 27 - as of course it is an integer. Shouldn't it be stored as a string field - like char(4)? That would give a correct "0027" as the last four digits.... Mark Link to comment Share on other sites More sharing options...
Larry Posted March 8, 2012 Share Posted March 8, 2012 You could store it as a CHAR(4), if you want, or just apply the zerofil property to the integer column. 1 Link to comment Share on other sites More sharing options...
Recommended Posts