On Fri, 27 Apr 2001, Phill Kenoyer wrote:
> > "zip" int8 NOT NULL,
>
> then 00315. Using VARCHAR() also gives you some breathing room
> if you add non-US postal codes, since practically every country
> uses alphanumeric systems.
I couldn't agree more. It is very annoying not to be able to input
Brazilian zip codes in US systems. Even if they accept letters, our system
is in the form 99.999-999 -- that's 10 characters, or 9 if you omit the dot,
but omiting the hyphen is so unusual it goes against the grain. Even if we
use just the numbers it's still 8 numbers, and most US systems do not accept
more than six, which force us to use, not the first six numbers (that would
be a mistake and then the letter might take weeks more to arrive than usual)
but only the first five numbers - while it isn't a gross error it is still a
serious omission and will delay the correspondence for some days.
--
_
/ \ Leandro Guimarães Faria Corcete Dutra +55 (11) 3040 8913
\ / Amdocs Brasil Ltda at Tele Danmark +45 3387 5214
X http://geocities.com./lgdutra/ mailto:leandrod@amdocs.com
/ \ Campanha fita ASCII mailto:moreno@tdk.dk