SQLTYPE

Display Size

EDS_SQL_CHAR

The defined length of the

EDS_SQL_VARCHAR

column. For example, the display size of a column defined as CHAR(10) is 10.

EDS_SQL_LONGVARCHAR

The maximum length of the column.

EDS_SQL_DECIMAL

The precision of the column

EDS_SQL_NUMERIC

plus 2 (a sign, precision digits, and a decimal point). For example, the display size of a column defined as NUMERIC(10,3) is 12.

EDS_SQL_BIT

1 (1 digit).

EDS_SQL_TINYINT

4 (a sign and 3 digits).

EDS_SQL_SMALLINT

6 (a sign and 5 digits).

EDS_SQL_INTEGER

11 (a sign and 10 digits).

EDS_SQL_BIGINT

20 (a sign and 19 digits).

EDS_SQL_REAL

13 (a sign, 7 digits, a decimal point, the letter E, a sign, and 2 digits).

EDS_SQL_BINARY EDS_SQL_VARBINARY

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 BINARY(10) is 20.

EDS_SQL_LONGVARBINARY

The maximum length of the column times 2.

EDS_SQL_DATE

10 (a date in the format yyyy-mm-dd).

EDS_SQL_TIME

8 (a time in the format hh:mm:ss).

EDS_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”)