Mysql - Mysql datatype varchar vs mediumtext, Which data type is better to use
Mysql datatype varchar vs mediumtextAnswering this question is difficult, some one thinks its silly question and even this might not be considered as a question by few developers. But actually for developers in beginning stage, it might be difficult to make decision which data type has to be selected. To be honest even I cant answer this question because it depends on the requirement. The below values might make you to decide which datatype has to be used for storing text or strings. I wore this blog because I had confusion to choose TEXT or VARCHAR, VARCHAR or MEDIUMTEXT, TEXT or MEDIUMTEXT, MEDIUMTEXT or LONGTEXT. Still its a big question to answer. But you have to decide it based on your requirement.
Maximum TEXT length
The maximum size of a TEXT data type depends on which type of TEXT data type is being used. Because they are stored as objects, the only row overhead in the table object is a pointer (8 or 16 bytes). Here is a list of the maximum TEXT length, and the overhead (in the TEXT object):
VARCHAR - up to 65,532 bytes. TINYTEXT - up to 255 bytes, 1 byte overhead TEXT - up to 64 Kb, 2 bytes overhead MEDIUMTEXT - up to 16 Mb, 3 bytes overhead LONGTEXT - up to 4 Gb, 4 bytes overhead
The topic on Mysql - Mysql datatype varchar vs mediumtext is posted by - Math
Hope you have enjoyed, Mysql - Mysql datatype varchar vs mediumtextThanks for your time