in reply to Re: Question about phone number storage.
in thread Question about phone number storage.

Unless the database is huge or performance isn't a concern you should probably just use a char field. The real payoff of varchar is wildly variable data where most of the time the varchar field would be small. In these days of huge hard-drives you might as well fix the field at the largest size and get the performance win of the DB knowing how many records per page you will have. If neither performance nor size matter, do what-ever makes you happy! =)

varchar for size, char for speed

P.S. The same boss that insists on int's will one day ask you how you can get (1-555-use-perl) in that DB...

--
$you = new YOU;
honk() if $you->love(perl)

  • Comment on Re: Re: Question about phone number storage.