SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
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 handled 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
{ 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 }