October 2001
Beginner to intermediate
400 pages
7h 45m
English
PostgreSQL includes three basic data types for storing string-related data. In compliance with the SQL standard, there are types for fixed-length and variable-length character strings. Additionally, PostgreSQL defines a more generic data type named TEXT that requires no specified upper limit regarding maximum size. However, this data type is PostgreSQL-specific and is not compliant with the SQL-92 standards.
Holds a fixed-length string specified with a maximum length.
CHAR(n)
n—Integer length of string (if omitted, a 1 is assumed).
(4+n) bytes
CHAR is a SQL-92-compatible data type. Data that does not fill to the limit specified is blank padded.
Read now
Unlock full access