[Year 12 IT Apps] Data type for postcode

[Wayne Eglinton]

FYI

living in the NT ... I'm fully aware of the 0 lead character in postcodes. Too bad web-developers don't consider using text for post/zipcodes fields ... often we can't subscribe etc... It can seriously be a pain - and we just go to another website... bad for their business!!!

Food for thought for you & your students.

Regards,

Wayne Eglinton

OLSH College
P.O. Box 2508
Traeger Ave.
Alice Springs NT 0871

P 08 8950 8555
M 0406 357 972

________________________________
From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] On Behalf Of Stuart Walkerden (STUW) [stuw at huntingtower.vic.edu.au]
Sent: 28 May 2013 13:20
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Data type for postcode

I reckon if it looks like a number, treat it as a number and use a number field type. Whether you perform calculations on it or not is irrelevant. I have always told my students to  use postcode as a number and phone as text to allow for leading 0. I wasn’t aware of NT postcodes. I may have to change my line.

Stuart Walkerden
Huntingtower

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Athena Spyratos
Sent: Tuesday, 28 May 2013 7:47 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Data type for postcode

Fellow IT teachers.
Do we declare the data type for Postcode as number or text? In database, if we apply a validation rule for a Victorian postcode as being between 3000 and 3999, then we declare it as a number. However going over one of the past exam multiple choice questions, the answer they wanted for the data type for Postcode was text. Which answer are the examiners looking for?
Athena
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130529/0e66281c/attachment.html