text length in mysql code example
Example 1: mysql text type max length
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
Example 2: mysql string length
-- Relevant for MySQL only
-- syntax
LENGTH(<your-string>)
-- example
LENGTH('CountCharacters') -- OUTPUT: 15
123456789012345
-- example with query
SELECT 'CountCharacters',LENGTH('CountCharacters')
FROM DUAL;
-- OUTPUT: CountCharacters, 15