(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
automatically generated byinfo2html