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

[Watson, Donald R]

Exactly

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark Scott
Sent: Thursday, 30 May 2013 10:00 AM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: Re: [Year 12 IT Apps] database convention - postcodes as a text field in databases

Hi

Now do we have a debate about the worth of Wikipedia as a source of information?

Maybe another day.

:)

Mark

Mark Scott
Daily Administrator
Luther
Plymouth Road
Croydon Hills Victoria 3136
Luther
Telephone (03) 9724 2000
Direct Line (03) 9724 2023
www.luther.vic.edu.au<http://www.luther.vic.edu.au/>

[Luther College]<http://www.luther.vic.edu.au/>

Please consider the environment before printing this email.

This email and any attachments may contain privileged and confidential information.
If you are not the intended recipient you may not distribute or reproduce this email
or attachments. If you have received this message in error please notify us by return mail.


From: itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Watson, Donald R
Sent: Thursday, 30 May 2013 9:45 AM
To: itapps at edulists.com.au<mailto:itapps at edulists.com.au>
Subject: [Year 12 IT Apps] database convention - postcodes as a text field in databases

Hello All,

The link below pretty much says it all.

The 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.

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130530/3f7af811/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 12076 bytes
Desc: image001.png
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20130530/3f7af811/image001-0001.png