[thelist] authorize.net transaction ID value

Ben Dyer radicalbender at gmail.com
Wed Jul 30 16:24:51 CDT 2008

In MySQL, 2,147,483,647 corresponds to the INT type (signed).  So, if
you are using MySQL for your software (you didn't say what you were
using), you need to make sure that the transaction ID field is either
an *unsigned* INT (goes up to values of 4,294,967,295) or BIGINT (over
9 quintillion signed or 18 quintillion unsigned).

Don't know about other database programs. Maybe someone can chime in with that.

If you could give us a little more info about your setup, that would
probably help.


On Wed, Jul 30, 2008 at 4:20 PM, Bob Meetin <bobm at dottedi.biz> wrote:
> I received an automated message a little bit ago from authorize.net
> informing me/us that whatever eCommerce solution in use must be able to
> accept transaction ID (x_trans_id) values greater than 2,147,483,647.
> Are any of you familiar with how to check this, and/or any eCommerce
> programs that are likely to have problems with this now?  -Bob
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

Radical Bender

More information about the thelist mailing list