What is the length and type of PayPal Transaction ID (txn_id)?

I want to store PayPal transaction IDs. What is the length and type that I need to set in this field in the database? I have currently installed varchar(128) . is that enough?

+7
source share
2 answers

In the transaction search API, it assumes that the maximum length of a transaction identifier is 19 separate bytes. The transaction ID is alphanumeric, so varchar(19) will be fine.

Personally, I would go for varchar(20) in case they exceed the maximum amount on transaction IDs and you need to add an extra digit :)

+9
source

parent_txn_id If a call is returned, canceled, or canceled, this variable contains the txn_id of the original transaction, and txn_id contains the new identifier for the new transaction. Length: 19 characters Type: String

-one
source

All Articles