Which is the most widely required and used data type for representing values? String or character data types; it's easy, right? MySQL supports a wide range of string data types to fulfill different storage requirements. String data types are categorized into two categories: fixed length and variable length. CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET are the MySQL-supported string data types. The storage requirement for each data type is different and will be explained later in a separate section.
String data types
CHAR and VARCHAR data types
The CHAR data type is a fixed-length string data type in MySQL. The CHAR data type is often declared with a maximum number of characters that can be stored as follows...