*bump* No one has any insight into this? Please please please.
On Thu, Sep 2, 2010 at 11:47 AM, Michael Grant <[email protected]> wrote: > 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:336808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
