[Year 12 IT Apps] Data type for postcode

[Mark]

OK. I'm seriously thinking of compiling this thread into a series of
textbooks, starting with: "The Joy of Postal Codes, Volume 1: the Database
Storage Issues."

The complete international postal code smorgasbord can be found here...
http://en.wikipedia.org/wiki/List_of_postal_codes

Mark


On 3 June 2013 20:31, Roland Gesthuizen <rgesthuizen at gmail.com> wrote:

> Now I am curious .. wondering out aloud if countries insist upon anything
> other than traditional alphanumeric characters?
>
> From memory in London, the two letters at the end of the postcode numbers
> were only used to help divide up the mail for the postal delivery routes.
> Nothing special but I may be wrong.
>
> Regards Roland
>
> *Roland Gesthuizen* | eLearning Leader
> Keysborough College DEECD
> http://about.me/rgesthuizen
>
> "Never doubt that a small group of thoughtful, committed citizens
> can change the world; indeed it is the only thing that ever has."
> --Margaret Mead
>
> On 03/06/2013, at 2:20 PM, Andrew Shortell <shortell at get2me.net> wrote:
>
> also in USA there are ZIP codes that begin with two leading zeros
>
> Quote:
> many of the lowest ZIP codes, which begin with '0', are in the New England<http://en.wikipedia.org/wiki/New_England> region.
> Also in the '0' region are New Jersey<http://en.wikipedia.org/wiki/New_Jersey> (non-contiguous
> with the remainder of the '0' area), Puerto Rico<http://en.wikipedia.org/wiki/Puerto_Rico>,
> the US Virgin Islands <http://en.wikipedia.org/wiki/US_Virgin_Islands>
>  and APO/FPO <http://en.wikipedia.org/wiki/APO/FPO> military addresses
> for personnel stationed in Europe <http://en.wikipedia.org/wiki/Europe>,
> Africa <http://en.wikipedia.org/wiki/Africa>, Southwest Asia<http://en.wikipedia.org/wiki/Southwest_Asia> and
> aboard vessels based in the waters adjoining those lands; APO/FPO addresses
> are also used by U.S. diplomatic and consulary facilities. The lowest ZIP
> code is in Holtsville, New York<http://en.wikipedia.org/wiki/Holtsville,_New_York> (00501,
> a ZIP code exclusively for the U.S. Internal Revenue Service<http://en.wikipedia.org/wiki/U.S._Internal_Revenue_Service> center
> there).
>
> source http://en.wikipedia.org/wiki/Zip_Codes
>
> Also they too have postcodes/zip codes that cross state boundaries for
> post office convenience
>
> This has certainly become esoteric and thus fascinating!
> Andrew
>
>   Andrew Shortell
> Educator
> CRC Melton
>
>
> shortell at get2me.net (This List)
> @acsbear8 (twitter)
> VITTA <http://www.vitta.org.au/> CoM Member
>
> <snip>

--
Mark Kelly
mark AT vceit DOT com
http://vceit.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130604/f0c72821/attachment.html