Keep It Simple, Stupid | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
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... -- In reply to Re: Re: Question about phone number storage.
by extremely
|
|