Monday, January 2, 2017

Maximum size of TEXT field in MySQL DB

Maximum size for TEXT field in a MySQL database is usually  64 Kilobytes. If you need more space, you can choose MEDIUMTEXT or LONGTEXT,as shown in table below.

Type       | Approx. Length     | Exact Max. Length Allowed
-----------------------------------------------------------
TINYTEXT   | 256 Bytes          | 255 characters
TEXT       | 64  Kilobytes      | 65,535 characters
MEDIUMTEXT | 16  Megabytes      | 16,777,215 characters
LONGTEXT   | 4   Gigabytes      | 4,294,967,295 characters
Please note: If you are using UTF8 or similar multi-byte encoding, 
the actual length will be lower.

No comments:

Post a Comment

Ubuntu 12.04, 14.04, 16.04 - auto start an app or script before login

To run a command or application at startup, even before the user has logged in, you can use this file: /etc/rc.local The commands entered...