<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
span.EmailStyle18
{font-family:"Arial","sans-serif";
color:#1F497D}
span.BalloonTextChar
{font-family:"Tahoma","sans-serif"}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Hi folks,
</span></a></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">After many years working on the back-end structures of the white and yellow pages, I can say for a certainty, that they store the postcodes as a text field
– and the phone numbers too, in fact virtually everything from the size of the ad (categories) to the street number is stored as text. Again, partly due to the lack of arithmetic needed (the cost of the ad is based on the category, type of listing and a few
various other things) and mainly due to the size restrictions. There used to be around 15,000 - 30,000 updates per night, and when each historical transaction is saved for each number, that ends up being petabytes of data VERY quickly.
</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Cheers</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D">Damien</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black">Damien</span></b><b><span style="font-family:"Arial","sans-serif"; color:black">
</span></b><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black">Atkinson-Buck</span></b><span style="font-family:"Arial","sans-serif"; color:#1F497D"><br>
</span><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black">Head of Learning Area: Technology/Arts</span><span style="font-family:"Arial","sans-serif"; color:black"> </span><span style="font-family:"Arial","sans-serif"; color:#1F497D"><br>
</span><span style="font-family:"Arial","sans-serif"; color:#1F497D"><img width="750" height="2" id="_x0000_i1026" src="cid:image001.png@01CE5D5B.CC567BB0"></span><span style="font-family:"Arial","sans-serif"; color:#1F497D"></span></p>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="color:#1F497D"><img width="135" height="66" id="_x0000_i1025" src="cid:image002.png@01CE5D5B.CC567BB0"></span><span style="color:#1F497D"></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black">p:</span></b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black"> +61 3 9490 3848
</span><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:#1F497D"></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black">e:</span></b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black">
</span><a href="mailto:damien.atkinson-buck@ivanhoe.com.au"><span style="font-size:8.0pt; font-family:"Arial","sans-serif"">damien.atkinson-buck@ivanhoe.com.au</span></a><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:#1F497D">
</span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black">f:</span></b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black"> +61 3 9490 3490</span><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:#1F497D"></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:black">w:</span></b><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:#1F497D">
</span><a href="http://www.ivanhoe.com.au/"><span style="font-size:8.0pt; font-family:"Arial","sans-serif"">www.ivanhoe.com.au</span></a><span style="font-size:8.0pt; font-family:"Arial","sans-serif"; color:#1F497D"></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Mark [mailto:mark@vceit.com]
<br>
<b>Sent:</b> Thursday, 30 May 2013 12:03 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] database convention - postcodes as a text field in databases</span></p>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">But obviously UK postcodes include text characters, so they must be stored as text. This does not apply to Australian postcodes.</p>
<div>
<p class="MsoNormal">I can't remember if the original poster meant to store ANY post/zip code from around the world or not...</p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> </p>
<div>
<p class="MsoNormal">On 30 May 2013 09:44, Watson, Donald R <<a href="mailto:watson.donald.r@edumail.vic.gov.au" target="_blank">watson.donald.r@edumail.vic.gov.au</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal" style="">Hello All,</p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style="">The link below pretty much says it all. </p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style="">T<b>he convention</b> is that postcodes should defined and be input as text.</p>
<p class="MsoNormal" style="">Of course there could be circumstances in which a specialised database might need to use some ‘regional intelligence’ based on a postcode.
</p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style="">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.</p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style=""><a href="http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom" target="_blank">http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom</a></p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style=""> </p>
<p class="MsoNormal" style="">Don</p>
</div>
<p><b>Important - </b>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.</p>
</div>
<p class="MsoNormal"><br>
_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
</p>
<div>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal">-- </p>
<div>
<p class="MsoNormal">--</p>
<div>
<p class="MsoNormal">Mark Kelly</p>
</div>
<div>
<p class="MsoNormal">mark AT vceit DOT com</p>
</div>
<div>
<p class="MsoNormal"><a href="http://vceit.com" target="_blank">http://vceit.com</a></p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
<br>
<br>
<br>
<br>
Privacy, Virus and Copyright Warning<br>
<br>
The information contained in this electronic message (e-mail), and any files transmitted with it:<br>
<br>
* is intended for the named recipients only. If you have received this in error, please advise the sender and delete it and any copies immediately;<br>
* Any personal information in this email must be used in accordance with the Privacy Act 1988 and this always applies even if it has been sent to you in error.<br>
* represents the views of the sender and does not necessarily represent the views or formal advice of Ivanhoe Grammar School;<br>
* may be subject to Copyright, so no further use should be made of it without the author's permission.<br>
<br>
The School does not represent or warrant that the email or any files attached do not contain errors or are free from computer viruses or other defects nor does it accept responsibility for any loss or damage resulting directly or indirectly from the use of
the email or any attached files.
</body>
</html>