Learn SQL Database Programming

String data types in MySQL

Let's discuss the string data types in MySQL:

• CHAR: It is a fixed-length string, which can contain letters, numbers, and special characters. This type is blank-padded and contains trailing blanks in the field. This field can range from 0 to 255, and the default (if nothing is specified, that is, just using CHAR instead of CHAR(10)) is 1. The size in parenthesis denotes the maximum length of the char specified by the user when creating the data field with this type. The storage requirement for CHAR is size * n, where n <= size <= 255, where n is the number of bytes required for the max length character.
• VARCHAR: It is a variable-length string, which can contain letters, numbers, and special characters. This field ...