Data type display (CLI) table
The display size of
a column is the maximum number of bytes that are required to display
data in character form. You can define the display size for an 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_DECFLOAT | If the column is defined as DECFLOAT(16) then the display length is 24. If the column is defined as DECFLOAT(34) then the display length is 42. |
| SQL_SMALLINT | 6 (a sign and 5 digits). |
| SQL_INTEGER
|
11 (a sign and 10 digits).
|
| SQL_BIGINT
|
20 (a sign and 19 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 maximum 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_TYPE_DATE
|
10 (a date in the format yyyy-mm-dd). |
| SQL_TYPE_TIME
|
8 (a time in the format hh:mm:ss). |
| SQL_TYPE_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[.ffffffffffff]" 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 |
Twice 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. |
| SQL_XML
|
0
|