Is it a good idea to use an integer column for storing US ZIP codes in a database?
A numeric ZIP code is — in a small way — misleading. 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. Granted, for ZIP codes, no one is confused. However, for other number-like … Read more