in reply to International Addresses

I'm note sure what differences are required for English and French addresses unless you're talking about "Street/Rue" titles. For province names you can use the standard North American abbreviations (BC, AB, ON, QC, etc).

After that the postal code is pretty simple .. each province has one or more letters assigned to it. Ontario has five (I think) .. K, L, M, N and P. Québec has at least H and J. It's probably easier to code that relationsip in (shudder) JavaScript. As soon as a province is selected, you can derive the range of available first letters for the postal code from that.

--t. alex

"There was supposed to be an earth-shattering kaboom!" --Marvin the Martian

Replies are listed 'Best First'.
Re: Re: International Addresses
by krazken (Scribe) on Mar 06, 2002 at 19:17 UTC
    The only problem with the canadian postal codes and using the first byter to determine the province is that both the Northwest Territories and Nunavut both use X as their identifier. I will have to do this on a country by country basis that way I can introduce custom code per country. I have a book that contains the address formats of 193 countries, and I am using that as a starting place... I know this is massive, but there is nothing out there that does anything like this, and anyone who does any type of database work with international data will have a need for this.
      I have had a need for something like what you are doing. I gave up and just used 4 lines of free format text, except in the case of US addresses, for which I had formatting rules. What book has the address formats of 193 countries? I might buy that one.


      The more I learn, the less I think I know.

        The book is called Global Address Management, and the author is Graham Rhind. (It is like 350 bucks though)