Field type | Precision | Scale |
GDB tables | ||
gdbFieldTypeString | 231-1 - maximum field length in characters. | 0 |
gdbFieldTypeInteger | 78911 decimal digits. | 0 |
gdbFieldTypeDouble | 15 decimal digits of mantissa. | 0 |
gdbFieldTypeBoolean | 1 decimal digit. | 0 |
gdbFieldTypeDate | 10 - the number of characters in the format yyyy-mm-dd. | 0 |
gdbFieldTypeTime | 8 - the number of characters in the format hh:mm:ss. | 0 |
gdbFieldTypeTimestamp | 19 - the number of characters in the format yyyy-mm-dd hh:mm:ss. | 0 |
gdbFieldTypeOLEObject | 231-1 - maximum length of embedded OLE object in bytes. | 0 |
External database tables | ||
gdbExtDBFieldTypeChar | Declared field length in characters. | 0 |
gdbExtDBFieldTypeVarChar | Declared maximum field length in characters. | 0 |
gdbExtDBFieldTypeLongVarChar | Maximum field length in characters or 0 if an ODBC data source cannot provide information about field length. | 0 |
gdbExtDBFieldTypeWChar | Declared field length in characters. | 0 |
gdbExtDBFieldTypeWVarChar | Declared maximum field length in characters. | 0 |
gdbExtDBFieldTypeWLongVarChar | Maximum field length in characters or 0 if an ODBC data source cannot provide information about field length. | 0 |
gdbExtDBFieldTypeDecimal | Declared number of decimal digits. | The number of decimal digits to the right of the decimal point. |
gdbExtDBFieldTypeNumeric | Declared number of decimal digits | The number of decimal digits to the right of the decimal point. |
gdbExtDBFieldTypeBit | 1 decimal digit. | 0 |
gdbExtDBFieldTypeTinyInt | 3 decimal digits. | 0 |
gdbExtDBFieldTypeSmallint | 5 decimal digits. | 0 |
gdbExtDBFieldTypeInteger | 10 decimal digits. | 0 |
gdbExtDBFieldTypeBigInt | 19 decimal digits if signed or 20 if unsigned. | 0 |
gdbExtDBFieldTypeReal | 7 decimal digits of mantissa. | 0 |
gdbExtDBFieldTypeFloat | 15 decimal digits of mantissa. | 0 |
gdbExtDBFieldTypeDouble | 15 decimal digits of mantissa. | 0 |
gdbExtDBFieldTypeBinary | Declared field length in bytes. | 0 |
gdbExtDBFieldTypeVarBinary | Declared maximum field length in bytes. | 0 |
gdbExtDBFieldTypeLongVarBinary | Maximum field length in bytes or 0 if an ODBC data source cannot provide information about field length. | 0 |
gdbExtDBFieldTypeDate | 10 - the number of characters in the format yyyy-mm-dd. | 0 |
gdbExtDBFieldTypeTime | 8 - the number of characters in the format hh:mm:ss. | 0 |
gdbExtDBFieldTypeTimeStamp | The number of characters in the format yyyy-mm-dd hh:mm:ss[.f…]. | The number of digits in the fraction (to the right of the decimal point). |
 |  |
