International Address Table

[ousoonerjoe]

Using 2008 R2.

We're finally getting to where we can convert the old table structures into a real database with relational structures and everything! (long story). I am looking for suggestions for an Addresses Table that supports international addresses. There's a million different ways to do this, but would like some your thoughts on this.

Currently, I'm looking at:

AddressId INT SEED
Street1 VARCHAR(60)
Street2 VARCHAR(60)
Street3 VARCHAR(60)
City VARCHAR(50)
StateId SMALLINT
ProvinceId SMALLINT
CountryId SMALLINT

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[MasterRacker]

You may find some help here:

http://blink.ucsd.edu/facilities/services/mail/international/addressing/index.html

http://www.columbia.edu/~fdc/postal/

On a related note, if you're international, this item about names might be interesting:

http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]