The display size of a column is the maximum number of bytes
needed to display data in character form. The following table defines the
display size for each SQL data type.
| fSqlType | Display Size |
|---|---|
SQL_CHAR SQL_VARCHAR SQL_CLOB | The defined length of the column. For example, the display size of a column defined as CHAR(10) is 10. |
SQL_LONGVARCHAR | The maximum length of the column. |
SQL_DECIMAL SQL_NUMERIC | The precision of the column plus two (a sign, precision digits, and a decimal point). For example, the display size of a column defined as NUMERIC(10,3) is 12. |
| SQL_SMALLINT | 6 (a sign and 5 digits). |
SQL_INTEGER |
11 (a sign and 10 digits). |
SQL_REAL | 13 (a sign, 7 digits, a decimal point, the letter E, a sign, and 2 digits). |
SQL_FLOAT SQL_DOUBLE | 22 (a sign, 15 digits, a decimal point, the letter E, a sign, and 3 digits). |
SQL_BINARY SQL_VARBINARY SQL_BLOB | The defined length of the column times 2 (each binary byte is represented by a 2 digit hexadecimal number). For example, the display size of a column defined as CHAR(10) FOR BIT DATA is 20. |
SQL_LONGVARBINARY | The maximum length of the column times 2. |
SQL_DATE | 10 (a date in the format yyyy-mm-dd). |
SQL_TIME | 8 (a time in the format hh:mm:ss). |
SQL_TIMESTAMP | 19 (if the scale of the timestamp is 0) or 20 plus the scale of the timestamp (if the scale is greater than 0). This is the number of characters in the "yyyy-mm-dd hh:mm:ss[fff[fff]]" format. For example, the display size of a column storing thousandths of a second is 23 (the number of characters in "yyyy-mm-dd hh:mm:ss.fff"). |
SQL_GRAPHIC SQL_VARGRAPHIC SQL_DBCLOB | The defined length of the column or parameter. For example, the display size of a column defined as GRAPHIC(10) is 20. |
| SQL_LONGVARGRAPHIC | The maximum length of the column or parameter. a |