Re:Old, Good Database Design
by bleepblorp on Monday September 14, 2020 @08:35PM
(#24476698)
Don't even try to do validation on postal addresses. The postal system has so many corner cases that you'll never be able to correctly handle all of them. Every mishandled corner case will cost you, or your counter-party, time and money.
Just dump addresses into a unicode string and let the postal system figure it out.
Just dump addresses into a unicode string and let the postal system figure it out.