(mysql.info.gz) BINARY VARBINARY

Info Catalog

(mysql.info.gz) CHAR

(mysql.info.gz) String types

(mysql.info.gz) BLOB

 
 11.4.2 The `BINARY' and `VARBINARY' Types
 -----------------------------------------
 
 The `BINARY' and `VARBINARY' types are like `CHAR' and `VARCHAR',
 except that they contain binary strings rather than non-binary strings.
 That is, they contain byte strings rather than character strings. This
 means they have no character set and compare in case sensitive fashion.
 
 Before MySQL 4.1.2, `BINARY(M)' and `VARBINARY(M)' are treated as
 `CHAR(M) BINARY' and `VARCHAR(M) BINARY'.  As of MySQL 4.1.2, `BINARY'
 and `VARBINARY' are available as distinct data types, and for `CHAR(M)
 BINARY' and `VARCHAR(M) BINARY', the `BINARY' attribute does not cause
 the column to be treated as a binary string column. Instead, it causes
 the binary collation for the column character set to be used, but the
 column itself contains non-binary character strings rather than binary
 byte strings. For example, in 4.1 and up, `CHAR(5) BINARY' is treated
 as `CHAR(5) CHARACTER SET latin1 COLLATE latin1_bin', assuming that the
 default character set is `latin1'.
 

Info Catalog

(mysql.info.gz) CHAR

(mysql.info.gz) String types

(mysql.info.gz) BLOB