database postcode field size - paypal table: Data too long for column 'address_zip'

[torvista]

PHP Fatal error: MySQL error 1406: Data too long for column 'address_zip' at row 1 ::
INSERT INTO paypal
(order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, mc_currency, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo)
VALUES ....

Yes this was a long postcode: 4445-649 ERMESINDE from Portugal.

From Wikipedia for Portugal
".... is formed by four digits, a hyphen, then three digits, followed by a postal location of up to 25 characters in capitals."
Sounds like the "postcode" could be longer than the address!!

Default address_book and paypal postcode fields are 10 characters.

I find that my address_book has long been 34 characters, but I'd never changed the paypal one.

Obviously not a common problem...
https://www.zen-cart.com/showthread.php?186400-How-to-change-the-maximum-length-for-postcode

[lat9]

The field length for the three xxx_postcode fields in the orders table will also need "expansion".

[lat9]

Might as well round the lengths up to the next power of two, i.e. varchar(64).