[Year 12 IT Apps] Data type for postcode

[Mark]

On the one hand, it is possible to do arithmetic with postcodes (e.g. to
find neighbouring areas) so number is good.
On the other hand, some postcodes have leading zeroes, which would be
thrown away if stored as number.

The best bet, I'd say, is to store them as number and format them with zero
padding to 4 digits for output purposes.


On 28 May 2013 07:47, Athena Spyratos <SP at boxhillhs.vic.edu.au> wrote:

>    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
>
> --
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/20130528/5c730ec7/attachment.html