NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-2
Data Types
CHAR[ACTER]
specifies a column with character data.
Unless you specify additional clauses, data type CHAR specifies a fixed-length,
single-byte column with an UNKNOWN character set and a collating sequence
based on the binary values of the characters.
VARYING
specifies that the number of characters in a value stored in the column can be fewer
than the maximum number of characters allowed in the column. Unless you specify
VARYING, each item stored in the column is treated as having the maximum length
for the column.
Note that values in a column declared as VARYING can be logically shorter than the
maximum length, but the internal size of a VARYING column is actually two bytes
larger than the size required for an equivalent column that is not VARYING.
len
is a positive integer that specifies the maximum number of characters allowed in the
column.
The maximum value you can specify for len depends on the file organization of the
table that contains the column, on whether the character set associated with the
{ DATETIME [ start-date-time TO ] end-date-time }
{ }
{ DATE }
{ }
{ TIME }
{ }
{ TIMESTAMP }
{ }
{ INTERVAL start-field [(sf-prec)] [ TO end-field ] }
charset is:
{ ISO88591 }
{ ISO88592 }
{ ISO88593 }
{ ISO88594 }
{ ISO88595 }
{ ISO88596 }
CHAR[ACTER] SET { ISO88597 }
{ ISO88598 }
{ ISO88599 }
{ KANJI }
{ KSC5601 }
{ UNKNOWN }