Name
CHAR
Syntax
CHAR(size) [BINARY]
Size
Specified by the size
value in a range of
to 255 (1 to 255 prior to MySQL 3.23)
Storage
size
bytes
Description
A fixed-length text field. String values with fewer characters than the column’s size will be right padded with spaces. The right padding is removed on retrieval of the value from the database.
CHAR(0)
fields are useful for backward
compatibility with legacy systems that no longer store values in the
column.
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.