Need help regarding data types in mySQL
Hi guys ,
I need your help to select the most appropriate data type in mysql to store a large body of textual information
Hi guys ,
I need your help to select the most appropriate data type in mysql to store a large body of textual information
Hi,
In mysql you can store data as your preferable size. If your textual information within 64KB then you use “TEXT” attribute. If your textual information is more than 64KB then you should use “MEDIUMTEXT”. If you have a very large textual information and you want to use it then use “LONGTEXT”. Hope your problem will be solved. Thanks
Hi there. So you’re doing a blog or an informative website perhaps? If you’ve got a bulk of text information (character strings) that you want to store in mysql, then you can choose either of the following 2:
MEDIUMTEXT – this data type can hold up to 16,777,215 bytes (that’s 16 MB of characters)
LONGTEXT – this data type can hold up to 4,294,967,295 bytes (4 GB of characters)
In some cases, BLOB (Binary Large Objects) is used. BLOB types actually hold the same amount of bytes like TEXT but this is often used for binary such as images or files other than character strings. Hopefully my answer can help you decide.