Re: field size for common data
| From: | Justin French | Date: | Sat, 28 Sep 2002 05:51:56 +0000 |
| Subject: | Re: field size for common data | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-117920@lists.php.net to get a copy of this message | ||
I'm no expert on MySQL field types, but I'd be going for a varchar field of
50-ish (maybe more???)... the reason is that (from what I understand)
varchar fields only take up as much room as the content, plus one or two
bytes, so making them 50 vs 30 will offer no advantage, but may become a
disadvantage down the track.
It'd be worth checking the MySQL manual though.
Justin
on 28/09/02 3:24 PM, Pablo Oliva (poliva@cox.net) wrote:
> What amount of chars is reasonable and should I allow for each of the
> following fields in a database:
>
> company name: 30 chars
> address/street: 30 chars
> city: 30 chars
>
> ???? Thanks.
>