Skip to main content

Posts

Showing posts with the label Text String Type

String Data Types

A string data type is a data type modeled on the idea of a formal string. They are commonly used to store  text or binary data. Types are available to hold values of varying maximum lengths and can be chosen  according to if the values are to be treated as text, binary or integer. Strings are such an important and  useful data type that they are implemented in nearly every programming language. Text String Type Summary For the storage requirement values, M represents the maximum length of a column. L represents the actual  length of a given value, which may be 0 to M. CHAR( )                       A fixed section from 0 to 255 characters long. VARCHAR( )               A variable section from 0 to 255 characters long. TINYTEXT                   A string with a maximum length of 255 characters. TEXT                            A string with a maximum length of 65535 characters. MEDIUMTEXT            A string with a maximum length of 16777215 characters. LONGTEXT