Unfortunate XML demand from USPS - 35 character limit address line international

[sbbemn]

Looks like by doing the following, it then only affects new customers during create_account.

ALTER TABLE address_book MODIFY entry_street_address varchar(35);
ALTER TABLE address_book MODIFY entry_suburb varchar(35);

We will have to now monitor all returning customer international shipments. Quite a drag.

[jc8125]

not sure if you're doing something different, but running that command will in fact truncate the existing entries down to 35 characters.. you might want to make sure you didn't just chop off half of your customers' addresses..

[sbbemn]

I tested on a sandbox and it only affected the entry field of a new account creation.

All customer addresses stayed in tact.

[sbbemn]

HOLD ON...

I looked at orders, which are unaffected.

The customer address_book table is indeed all cut off.

How can I direct that only new entries have a max characters of 35 and current addresses remain unchanged?