String Data Types
String data types store various kinds of
text data. There are several types to accomodate data of different
sizes. For each size, there is a type that sorts and compares entries
in a case-insensitive fashion in accordance with the sorting rules
for the default character set and a corresponding binary type that
does simple byte-by-byte sorts and comparisons. In other words,
binary values are case sensitive. For CHAR and
VARCHAR, the binary types are declared using the
BINARY attribute. The TEXT
types, however, have corresponding BLOB types as
their binary counterparts.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
