Name
VARCHAR
Syntax
VARCHAR(size) [BINARY]
Size
Specified by the size
value in a range of
to 255 (1 to 255 prior to MySQL 3.23)
Storage
Length of value + 1 byte
Description
Storage for variable-length text. Trailing spaces are removed from
VARCHAR
values when stored in a database that
conflicts with the ANSI specification.
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.