subject:"\[PHP\] field size for common data"

Re: [PHP] field size for common data

2002-09-27 Thread Justin French

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 disadv

[PHP] field size for common data

2002-09-27 Thread Pablo Oliva

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.