|
|
|
| Problems? Is your data what you think it is? | |
| PerlMonks |
Re: Re: Question about phone number storage.by extremely (Priest) |
| on Jan 19, 2001 at 00:05 UTC ( [id://52897]=note: print w/replies, xml ) | Need Help?? |
This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.
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 Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||