gdbFieldTypeString

Variable-length string of characters. A character size is 1 byte. The maximum string length is 2³¹-1 bytes for unindexed fields and 490 bytes for indexed fields.

gdbFieldTypeInteger

Numeric, integer. Range: ±2²⁶²¹³⁶-1 for unidexed fields and ±2³⁹²⁰-1 for indexed fields.

gdbFieldTypeDouble

Numeric, approximate. Range: from ±4.19?10^–308 to ±1.67?10³⁰⁸. Mantissa precision: 15 decimal digits.

gdbFieldTypeBoolean

Logical value.

gdbFieldTypeDate

Date. Range: from 1-Jan-0 to 31-Dec-9999.

gdbFieldTypeTime

Time. Range: from 0 hours 0 minutes 0 seconds to 23 hours 59 minutes 59 seconds.

gdbFieldTypeTimestamp

Timestamp. The type is a combination of date types and time types. The range corresponds to ranges of date and time.

gdbFieldTypeOLEObject

Embedded or linked OLE object.

gdbExtDBFieldTypeChar

Fixed-length string of characters. The string length in characters is determined by the Field::Precision property.

gdbExtDBFieldTypeVarChar

Variable-length string of characters. The maximum string length in characters is determined by the Field::Precision property.

gdbExtDBFieldTypeLongVarChar

Variable-length string of characters. The maximum allowable length of a field is determined by the Field::Precision property.

gdbExtDBFieldTypeWChar

Fixed-length string of UNICODE characters. The string length in characters is determined by the Field::Precision property.

gdbExtDBFieldTypeWVarChar

Variable-length string of UNICODE characters. The maximum string length in characters is determined by the Field::Precision property.

gdbExtDBFieldTypeWLongVarChar

Variable-length string of UNICODE characters. The string length in characters is determined by the Field::Precision property.

gdbExtDBFieldTypeDecimal

Numeric, exact. The property Field::Precision returns the total number of decimal digits. The property Field::Scale returns the number of decimal digits to the right of the decimal point.

gdbExtDBFieldTypeNumeric

Numeric, exact. The property Field::Precision returns the total number of decimal digits. The property Field::Scale returns the number of decimal digits to the right of the decimal point.

gdbExtDBFieldTypeBit

Logical value.

gdbExtDBFieldTypeTinyInt

Numeric, integer. Ranging from –128 to 127 for negative values or from 0 to 255 for positive values.

gdbExtDBFieldTypeSmallint

Numeric, integer. Ranging from -32,768 to 32,767 for negative values or from 0 to 65,535 for positive values.

gdbExtDBFieldTypeInteger

Numeric, integer. Ranging from –2³¹ to 2³¹ -1 for negative values or from 0 to 2³² -1 for positive values.

gdbExtDBFieldTypeBigInt

Numeric, integer. Ranging from –2⁶³ to 2⁶³ -1 for negative values or from 0 to 2⁶⁴ -1 for positive values.

gdbExtDBFieldTypeReal

Numeric, approximate. Ranging from 10^–38 to 10³⁸.

gdbExtDBFieldTypeFloat

Numeric, approximate. Ranging from ±4.19?10^–308 to ±1.67?10³⁰⁸. Mantissa precision: 15 decimal digits.

gdbExtDBFieldTypeDouble

Numeric, approximate. Ranging from ±4.19?10^–308 to ±1.67?10³⁰⁸.. Mantissa precision: 15 decimal digits.

gdbExtDBFieldTypeBinary

Fixed-length sequence of bytes. The sequence length in bytes is determined by the Field::Precision property.

gdbExtDBFieldTypeVarBinary

Variable-length sequence of bytes. The maximum sequence length in bytes is determined by the Field::Precision property.

gdbExtDBFieldTypeLongVarBinary

Variable-length sequence of bytes. The maximum field length in bytes is determined by the Field::Precision property.

gdbExtDBFieldTypeDate

Data. The range depends on an ODBC data source.

gdbExtDBFieldTypeTime

Time. The range depends on an ODBC data source.

gdbExtDBFieldTypeTimeStamp

Timestamp. The range depends on an ODBC data source.