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 ([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