All opinions expressed are those of the authors and not necessarily those of OSNews.com, our sponsors, or our affiliates.

* End Point blog: Authorize.Net Transaction IDs to increase in size
published by noreply@blogger.com (Daniel Collis-Puro) on 2008-09-02 15:21:00 in the "e-commerce mysql credit-cards postgres" category

A sign of their success, Authorize.net is going to break through Transaction ID numbers greater than 2,147,483,647 (or 2^31), which happens to exceed the maximum size of a signed MySQL int() column and the default Postgres "integer".

It probably makes sense to ensure that your transaction ID columns are large enough proactively - this would not be a fun bug to run into ex-post-facto.

Comments