Just gone thru the maximum length limit for different MySQL TEXT field types. I’m designing a table to store large amount of data within a field. To avoid data being truncated automatically, it’s good to know the maximum length limit for different MySQL TEXT field types.
Here’s the summary for maximum length limit for different MySQL TEXT field types:
Advertisements
- TINYTEXT – 256 bytes – 256 character
- TEXT – 65,535 bytes (~64kb) – 65,535 character – around 16,383 UTF8 character
- MEDIUMTEXT – 16,777,215 bytes (~16MB) – 16,777,215 character – around 4,194,303 UTF8 character
- LONGTEXT – 4,294,967,295 bytes (~4GB) – 4,294,967,295 character – around 1,073,741,820 UTF8 character
* assuming one UTF8 character = 4 bytes.
Credit: MySQL Data Type Storage Requirement
Related posts:
Prestashop 1.6: How to show price in catalog mode?
Prestashop 1.5 - How to enable add to cart button at Home Featured Product?
WordPress: How to create left sidebar template in TwentyEleven theme?
How to setup multiple identities in Thunderbird?
Cynogenmod: No Vibration when Receiving SMS
Prestashop 1.6: "Unexpected token <" error when upload category thumbnail
GMail: Too many simultaneous connections (Failure) in Thunderbird
Rip DVD Movies with Handbrake
Share this with your friends:-