Redigera

Dela via


Display Size

The display size of a column is the maximum number of characters needed to display data in character form. The following table defines the display size for each ODBC SQL data type.

SQL type identifier Display size
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

[a] If the driver cannot determine the column or parameter length of variable types, it returns SQL_NO_TOTAL.