All character types[a]

The defined (for fixed types) or maximum (for variable types) number of characters needed to display the data in character form.

SQL_DECIMAL SQL_NUMERIC

The precision of the column 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.

SQL_BIT

1 (1 digit).

SQL_TINYINT

4 if signed (a sign and 3 digits) or 3 if unsigned (3 digits).

SQL_SMALLINT

6 if signed (a sign and 5 digits) or 5 if unsigned (5 digits).

SQL_INTEGER

11 if signed (a sign and 10 digits) or 10 if unsigned (10 digits).

SQL_BIGINT

20 (a sign and 19 digits if signed or 20 digits if unsigned).

SQL_REAL

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

SQL_FLOAT SQL_DOUBLE

24 (a sign, 15 digits, a decimal point, the letter E, a sign, and 3 digits).

All binary types[a]

The defined or maximum (for variable types) length of the column times 2. (Each binary byte is represented by a 2-digit hexadecimal number.)

SQL_TYPE_DATE

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

SQL_TYPE_TIME

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

- or -

9 + s (a time in the format hh:mm:ss[.fff...], where s is the fractional seconds precision).

SQL_TYPE_TIMESTAMP

19 (for a timestamp in the yyyy-mm-dd hh:mm:ss format)

- or -

20 + s (for a timestamp in the yyyy-mm-dd hh:mm:ss[.fff...] format, where s is the fractional seconds precision).

All interval data types

See Interval Data Type Length.

SQL_GUID

36 (the number of characters in the aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee format