Buy Aceon | Cheap Aceon | Buy Aceon Online
Buy Aceon | Cheap Aceon | Buy Aceon Online
FAQ
Search
Memberlist
Usergroups
Galleries
Register
Profile
Log in to check your private messages
Log in
Buy Aceon | Cheap Aceon | Buy Aceon Online Forum Index
->
Buy Aceon | Cheap Aceon | Buy Aceon Online
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Tiny
Small
Normal
Large
Huge
Close Tags
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
Confirmation code: *
All times are GMT + 2 Hours
Jump to:
Select a forum
Jakaś kategoria
----------------
Buy Aceon | Cheap Aceon | Buy Aceon Online
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thCornerL" width="22%" height="26">Author</th> <th class="thCornerR">Message</th> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>cheapbag214s</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="http://picsrv.fora.pl/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Wed 0:29, 14 Aug 2013<span class="gen"> </span> Post subject: Is it a good idea to use an integer column for sto</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Could it be smart to use an integer column for storing US ZIP codes inside a database <br />Both would satisfy the requirements of the data, if we assume that there aren't any international concerns. In the past we've generally just gone the text route, but I wondered if anyone does the opposite? Just from brief comparison it looks such as the integer method has two clear advantages: <br />It is,<a href="http://rogerviviershoes.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">Roger vivier uk</span></a>, by means of its nature,<a href="http://rogerviviershoesshoponline.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">Roger vivier uk</span></a>, automatically restricted to numerics only (whereas without validation the written text style could store letters and such which aren't, to my knowledge, ever valid inside a ZIP code). It doesn't mean we could/would/should forgo validating user input as normal, though! <br />Also, it seems like it wouldn't hurt display output much. It's trivial to slap a ToString() on the numeric value,<a href="http://giuseppezanottisneakerssale.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">giuseppe zanotti shoes</span></a>, use simple string manipulation to insert a hyphen or space or whatever for that +4 extension, and employ string formatting to restore leading zeroes. <br />Is there something that would discourage using int as a datatype for US-only ZIP codes? <br />Numbers should mean something numeric. ZIP codes don't add or subtract or participate in any numeric operations. 12309 - 12345 does not compute the distance from downtown Schenectady to my neighborhood,<a href="http://giuseppezanottisneakerssale.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">giuseppe zanotti shoes sale</span></a>. <br />Granted, for ZIP codes, we're not confused. However,<a href="http://giuseppezanottisneakerssale.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">giuseppe zanotti</span></a>, for other number-like fields, it may be confusing. <br />Since ZIP codes aren't numbers -- they just happen to be coded having a restricted alphabet -- I suggest avoiding a numeric field. The 1-byte saving isn't worth much. And i believe that that meaning is more important compared to byte. <br />Plus the leading-zero issue means you not storing the client real data,<a href="http://giuseppezanottisneakerssale.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">giuseppe zanotti outlet</span></a>, you storing some adjusted version from it that will need mental gymnastics to consider you have to look out for too-short codes. And let's say they included the +4? <br />There no benefit to storing them in numeric format that I can see. The only real operation I ever done on zip codes is by using them in long/lat calculations which requires you to treat them like strings anyway: you just grab the first 3 characters (leading zero problem again). Tom May 21 '09 at 15:43 <br />Normally you would employ a non-numerical datatype like a varchar which may permit more zip code types. If you're dead set on only allowing 5 digit [XXXXX] or 9 digit [XXXXX-XXXX] zip codes, you can then make use of a char(5) or char(10), but I would not recommend it. Varchar may be the safest and many sane choice. <br />Edit: It should be also noted that if you do not intend on doing numerical calculations about the field,<a href="http://giuseppezanottisneakerssale.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">giuseppe zanotti sandals</span></a>, you shouldn't use a numerical data type. ZIP Code is a not really a number in the sense that you simply add or subtract against it. It is just a string that happens to be made up typically of numbers, which means you should avoid using numerical data types for this. <br />From the technical standpoint,<a href="http://rogerviviershoes.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">roger vivier sandals</span></a>, some things raised here are fairly trivial. Sometimes with address data cleansing every day - particularly cleansing address data all over the world. It's not a trivial task by any stretch from the imagination. With regards to zip codes, you could store them as an integer even though it may not be "semantically" correct. The fact is, the data is of a numeric form whether, strictly speaking it is considered numeric in value. <br />It is also very hard to force the user to input correct data if a person from the repercussions is a delay of economic. Users often not have the patience to go in correct data whether it's not immediately obvious. Using a regex is an excellent method of guaranteeing correct data, however if the user enters a value that doesn't conform and they're displayed an error, they may just omit this value altogether or enter something which conforms but is otherwise incorrect. An example [using Canadian postal codes] is you often see A0A 0A0 entered which isn't valid but conforms to the regex for Canadian postal codes. More often than not,<a href="http://rogerviviershoesshoponline.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">roger vivier pumps</span></a>, this really is entered by users who are forced to give a postal code, however they either have no idea what it's or do not have everything correct. <br />One suggestion is to validate the whole of the entry like a unit validating the zip code is correct when compared with all of those other address. If it's incorrect, then offering alternate valid zip codes for the address will make it more convenient for these phones input valid data. Likewise, when the zip code is correct for that street address,<a href="http://rogerviviershoesshoponline.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">roger vivier sale</span></a>, but the street number falls outside the domain of that zipcode, then offer alternate street numbers for that zip code/street combination. <br />相关的主题文章： <br /> <br /> <br /> <a href="http://www.luntacunt.fora.pl/tips-tricks,8/innovation-and-a-diversified-approach-typifies-tim,7470.html#7734" target="_blank" class="postlink">http://www.luntacunt.fora.pl/tips-tricks,8/innovation-and-a-diversified-approach-typifies-tim,7470.html#7734</a> <br /> <br /> <a href="http://www.portfolk.fora.pl/koncerty,1/in-a-while-spun1,1802.html#2254" target="_blank" class="postlink">http://www.portfolk.fora.pl/koncerty,1/in-a-while-spun1,1802.html#2254</a> <br /> <br /> <a href="http://www.fingerlog.com/index.php?do=/user/login/" target="_blank" class="postlink">http://www.fingerlog.com/index.php?do=/user/login/</a> <br /> <br /> <a href="http://atarimae.jp/blog/027/2009/12/post-12.html#comments" target="_blank" class="postlink">http://atarimae.jp/blog/027/2009/12/post-12.html#comments</a> <br /> <br /> <a href="http://0403pjm.bbspace.org/viewthread.php?tid=15995&extra=page%3D1&frombbs=1" target="_blank" class="postlink">http://0403pjm.bbspace.org/viewthread.php?tid=15995&extra=page%3D1&frombbs=1</a> <br /> <br /> <a href="http://blogs.princeton.edu/pia/personal/xinjiang/2009/06/bureaucracy.html#comments" target="_blank" class="postlink">http://blogs.princeton.edu/pia/personal/xinjiang/2009/06/bureaucracy.html#comments</a> <br /> <br /> <a href="http://www.compazinegtccv.fora.pl/what-say-watery-smile-work-during-quiet-breath-ambien-strengths-loove-you-iscouraged,1/buying-few-toms-boots-is-ordinarily-getting-a-pair,2778.html#2802" target="_blank" class="postlink">http://www.compazinegtccv.fora.pl/what-say-watery-smile-work-during-quiet-breath-ambien-strengths-loove-you-iscouraged,1/buying-few-toms-boots-is-ordinarily-getting-a-pair,2778.html#2802</a> <br /> <br /> <a href="http://development.compuphonic.co.uk/index.php?do=/user/login/" target="_blank" class="postlink">http://development.compuphonic.co.uk/index.php?do=/user/login/</a> <br /> <br /> <a href="http://atarimae.jp/blog/027/2009/12/post-11.html#comments" target="_blank" class="postlink">http://atarimae.jp/blog/027/2009/12/post-11.html#comments</a> <br /> <br /> <a href="http://nlp.edu.vn/showthread.php?114573-Getting-to-know-more-about-Women-s-Boat-shoes-spun5&p=121880#post121880" target="_blank" class="postlink">http://nlp.edu.vn/showthread.php?114573-Getting-to-know-more-about-Women-s-Boat-shoes-spun5&p=121880#post121880</a> <br /> <br /> <a href="http://planetlivechat.com/chatcommunity/subscribe/" target="_blank" class="postlink">http://planetlivechat.com/chatcommunity/subscribe/</a> <br /> <br /> <a href="http://forum.zeload.com/viewtopic.php?f=30&t=557048" target="_blank" class="postlink">http://forum.zeload.com/viewtopic.php?f=30&t=557048</a> <br /> <br /> <a href="http://www.museyon.com/forum/viewtopic.php?f=2&t=528254" target="_blank" class="postlink">http://www.museyon.com/forum/viewtopic.php?f=2&t=528254</a> <br /> <br /> <a href="http://www.sportsprimetime.net/forums/showthread.php?p=1107113#post1107113" target="_blank" class="postlink">http://www.sportsprimetime.net/forums/showthread.php?p=1107113#post1107113</a> <br /> <br /> <a href="http://www.nifedipinerbzzp.fora.pl/most-often-metformin-hci-1000-mg-augmentin-generic-equipment,1/best-ski-resorts-on-the-u-spun4,10047.html#10295" target="_blank" class="postlink">http://www.nifedipinerbzzp.fora.pl/most-often-metformin-hci-1000-mg-augmentin-generic-equipment,1/best-ski-resorts-on-the-u-spun4,10047.html#10295</a></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="http://picsrv.fora.pl/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
fora.pl
- załóż własne forum dyskusyjne za darmo
Powered by
phpBB
© 2001, 2005 phpBB Group
Regulamin
FAQ
Search
Memberlist
Usergroups
Galleries
Register
Log in to check your private messages
Log in