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.


on 28/09/02 3:24 PM, Pablo Oliva ([EMAIL PROTECTED]) 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.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to