The following table shows the default if a CREATE TABLE, ALTER TABLE, or SELECT statement does not include the FORMAT phrase.
IF the data type is … | THEN … |
---|---|
CHARACTER | return the full length specified for a fixed-length CHARACTER column (that is, pad characters are returned unless TRIM is included in the SELECT statement). |
VARCHAR | return the actual character string. |
CLOB |
|