Am using text data type but cant inserted........
what data type is used for store large text in mysql
what data type is used for store large text in mysql
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
HanookPosted Nov 7, 2013, 11:48 PM
Data types and corresponding sizes in MySQL
TINYTEXT - 255 bytes
TEXT - 65535 bytes
MEDIUMTEXT - 16,777,215 bytes (2^24 - 1)
LONGTEXT - 4G bytes (2^32 – 1)
TINYBLOB - 255 bytes
BLOB - 65535 bytes
MEDIUMBLOB - 16,777,215 bytes (2^24 - 1)
LONGBLOB - 4G bytes (2^32 – 1)
HanookPosted Nov 7, 2013, 11:46 PM
Refer
http://dev.mysql.com/doc/refman/5.0/en/blob.html