Answers for "mysql long text length"

SQL
9

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
Posted by: Guest on July-06-2020
3

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
Posted by: Guest on May-08-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language