I've been wondering what exactly is the benefit of using a TEXT instead of a VARCHAR(10000) variable or something like that?
If I want to have a limit of 10000 letters, it's best to use a varchar right? Or is it best to use a text as maybe they take up less space?
--edit--
hmm, when I set a varchar(15000) in sql it just automatically changes it to TEXT...I guess that answers my question *shrugs*