Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so that the field best matches the data going into it.
As an example if I was storing some text data that was max 1000 chars I would use varchar(1000) and not a blob type. I've always thought that this prevented bloating. However I've just been told something that contradicts this and I'm wondering what you experts say. Is using the TEXT datatype completely variable how long it it? So if I insert a single character into a tinytext, text, mediumtext or longtext field it will only take up that much room in the db? Is that correct? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm