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.
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για