Maximum length for MySQL type text

by

See for maximum numbers:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

TINYBLOB, TINYTEXT       L + 1 bytes, where L < 2^8    (255 Bytes)
BLOB, TEXT               L + 2 bytes, where L < 2^16   (64 Kilobytes)
MEDIUMBLOB, MEDIUMTEXT   L + 3 bytes, where L < 2^24   (16 Megabytes)
LONGBLOB, LONGTEXT       L + 4 bytes, where L < 2^32   (4 Gigabytes)

L is the number of bytes in your text field. So the maximum number of chars for text is 216-1 (using single-byte characters). Means 65 535 chars(using single-byte characters).

UTF-8/MultiByte encoding: using MultiByte encoding each character might consume more than 1 byte of space. For UTF-8 space consumption is between 1 to 4 bytes per char.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MyISAM versus InnoDB [closed]
  3. How to select the nth row in a SQL database table?
  4. Compare two MySQL databases [closed]
  5. How should I resolve –secure-file-priv in MySQL?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Does MySQL index foreign key columns automatically?
  11. What’s the difference between MyISAM and InnoDB? [duplicate]
  12. What effects does using a binary collation have?
  13. MySQL SELECT increment counter
  14. Hyphens in column names in MySQL DB
  15. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  16. Error renaming a column in MySQL
  17. Modeling Product Variants
  18. Mysql database sync between two databases
  19. What’s the best database structure to keep multilingual data? [duplicate]
  20. Does mysql have the equivalent of Oracle’s “analytic functions”?
  21. MySQL concatenating all columns
  22. Using reserved words in column names
  23. FIND_IN_SET with multiple value [duplicate]
  24. What is the difference between SQL and MySQL? [closed]
  25. mysql Failed to read auto-increment value from storage engine
  26. MySQL: Check if the user exists and drop it
  27. WooCommerce: Finding the products in database
  28. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment