What are some datatypes for storing a string mysql has to of

What are some datatypes for storing a string mysql has to offer?

Solution

Mysql Data types for storing a string are as follows.

CHAR-->Contains a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis. Can store up to 255 characters.

VARCHAR-->Contains a variable length string (can contain letters, numbers, and special characters). The maximum size is specified in parenthesis. Can store up to 255 characters.

MEDIUMTEXT--> Contains a string with a maximum length of 16,777,215 characters.

LONGTEXT--> contains string with a maximum length of 4,294,967,295 characters.

DECIMAL--> A DOUBLE stored as a string , allowing for a fixed decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter.

TINYTEXT -->Contains a string with a maximum length of 255 characters.

TEXT-->Contains a string with a maximum length of 65,535 characters.