The answer by phpguy is correct but I think there is a lot of confusion in the additional details there. In SQL, we have …
A data type also specifies the possible values for that type, the operations that can be performed on that type and the way the values of that type are stored. Strings can be compared and searched based on pattern matching by using the LIKE operator, regular expression, and full-text search. in the table.
In MySQL, a string can hold anything from plain text to binary data such as images or files. Binary strings are merely a sequence of byte values, and because of this, such strings seem to be case-sensitive, because uppercase and lowercase characters have different byte values. The basic answer is in a BLOB data type / attribute domain. MySQL supports … For the latter types, the BINARY attribute does not cause the column to be treated as a binary string column. In binary data types, we have an option like allowing users to store fixed-length or variable length of bytes based on requirements. A data type specifies a particular type of data, such as integer, floating-point, Boolean etc.
The following table illustrates all string data types that support in MySQL: For the latter types, the BINARY attribute does not cause the column to be treated as a binary string column. When converting data from a string data type to a binary or varbinary data type of unequal length, SQL Server pads or truncates the data on the right. String Data Types: The string data type is used to hold plain text and binary data, for example, files, images, etc. The BINARY and VARBINARY data types are distinct from the CHAR BINARY and VARCHAR BINARY data types. These string data types are: char; varchar; nchar; nvarchar; binary MySQL can perform searching and comparison of string value based on the pattern matching such as LIKE operator, Regular Expressions, etc. See the relevant manual page for MySQL . Converting binary and varbinary data. The most important point to remember in case of binary string data type is that, binary strings don’t have character sets and collations. The following table shows the string data types in MySQL: A fixed-length nonbinary (character) string. The BINARY and VARBINARY data types are distinct from the CHAR BINARY and VARCHAR BINARY data types. In SQL, binary data types are used to store any kind of binary data like images, word files, text files, etc. BLOB is short for Binary Large Object and that column data type is specific for handling binary data.