[Year 12 IT Apps] database convention - postcodes as a text field in databases

[Mark]

But obviously UK postcodes include text characters, so they must be stored
as text. This does not apply to Australian postcodes.
I can't remember if the original poster meant to store ANY post/zip code
from around the world or not...


On 30 May 2013 09:44, Watson, Donald R
<watson.donald.r at edumail.vic.gov.au>wrote:

>  Hello All,****
>
> ** **
>
> The link below pretty much says it all. ****
>
> ** **
>
> T*he convention* is that postcodes should defined and be input as text.***
> *
>
> Of course there could be circumstances in which a specialised database
> might need to use some ‘regional intelligence’ based on a postcode. ****
>
> ** **
>
> A mail drop to all postcodes between 3850 and 3860 covers my area of
> Gippsland for example. It saves time on listing 100’s of towns in a
> complicated case or nested if statement.****
>
> ** **
>
> ** **
>
> http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> Don****
>
> *Important - *This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before opening
> or using attachments check them for viruses and defects. Regardless of any
> loss, damage or consequence, whether caused by the negligence of the sender
> or not, resulting directly or indirectly from the use of any attached files
> our liability is limited to resupplying any affected attachments. Any
> representations or opinions expressed are those of the individual sender,
> and not necessarily those of the Department of Education and Early
> Childhood Development.
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>



-- 
--
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/20130530/df6e616f/attachment.html