I'm teaching myself more and more about php and mysql as time permits.  I've
in the process of setting up a new table on an existing mysql database.  I
have a few questions:

When should I use "varChar" instead of, say, "text" or "blob"?

When should I use "int" instead of "tinyInt" or vice versa?

What are the advantages in the cases above of one or the other, or
advantages for other similar field types?

When should I make a field "not null" or "null"?  How important is this to
be set either way?

Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com

"Making database sites seem easy"

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA