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 |
|