Sql is used for creating databases which consists of tables. But what ot do if we want to store some data which is in the form of paragraph of text....... For eg if we want to store contents of 'about us' page of a website in database what we will do
Depending on the text size you can use any of the below TINYBLOB, TINYTEXT - L + 1 bytes, where L < 28 BLOB, TEXT - L + 2 bytes, where L < 216 MEDIUMBLOB, MEDIUMTEXT - L + 3 bytes, where L < 224 LONGBLOB, LONGTEXT - L + 4 bytes, where L < 232 For more on Datatypes in MySQL, refer this http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html