const func string: int8Type (in dbCategory: databaseKind)

Determine the SQL datatype capable to store 8-bit integers. This 8-bit integer datatype might be signed or unsigned.

Returns:

the name of the SQL datatype for 8-bit integers.

const func integer: maxInt8Value (in dbCategory: databaseKind)

Determine the maximum value for the 8-bit integer datatype. This maximum shows if the 8-bit integer datatype is signed or unsigned.

Returns:

the maximum value for the 8-bit integer datatype.

const func string: int64Type (in dbCategory: databaseKind)

Determine the SQL datatype capable to store 64-bit signed integers.

Returns:

the name of the SQL datatype for 64-bit integers.

const func string: floatType (in dbCategory: databaseKind)

Determine the SQL datatype capable to store single precision floats.

Returns:

the name of the SQL datatype for single precision floats.

const func string: doubleType (in dbCategory: databaseKind)

Determine the SQL datatype capable to store double precision floats.

Returns:

the name of the SQL datatype for double precision floats.

const func string: decimalIntType (in dbCategory: databaseKind)

Determine the SQL datatype capable to store the biggest decimal integers.

Returns:

the name of the SQL datatype for the biggest decimal integers.

const func integer: maxDecimalPrecision (in dbCategory: databaseKind)

Determine the maximum precision of the decimal datatype.

Returns:

the precision (number of digits) of the decimal datatype.

const func string: numericIntType (in dbCategory: databaseKind)

Determine the SQL datatype capable to store the biggest numeric integers.

Returns:

the name of the SQL datatype for the biggest numeric integers.

const func integer: maxNumericPrecision (in dbCategory: databaseKind)

Determine the maximum precision of the numeric datatype.

Returns:

the precision (number of digits) of the numeric datatype.

const func string: decimalType (in dbCategory: databaseKind, in integer: scale)

Determine the decimal datatype with the highest precision and a given scale.

Returns:

the name of the decimal datatype.

const func integer: minDecimalScale (in dbCategory: databaseKind)

Determine the minimum scale allowed for the decimal datatype.

Returns:

the minimum scale allowed for the decimal datatype.

const func integer: maxDecimalScale (in dbCategory: databaseKind)

Determine the maximum scale allowed for the decimal datatype. In several databases the scale must be less or equal to the precision. This function returns the maximum scale for the maximum precision.

Returns:

the maximum scale allowed for the decimal datatype.

const func string: numericType (in dbCategory: databaseKind, in integer: scale)

Determine the numeric datatype with the highest precision and a given scale.

Returns:

the name of the numeric datatype.

const func integer: minNumericScale (in dbCategory: databaseKind)

Determine the minimum scale allowed for the numeric datatype.

Returns:

the minimum scale allowed for the numeric datatype.

const func integer: maxNumericScale (in dbCategory: databaseKind)

Determine the maximum scale allowed for the numeric datatype. In several databases the scale must be less or equal to the precision. This function returns the maximum scale for the maximum precision.

Returns:

the maximum scale allowed for the numeric datatype.

const func string: varcharType (in dbCategory: databaseKind)

Determine the VARCHAR datatype of the database.

Returns:

the name of the VARCHAR datatype.

const func string: blobType (in dbCategory: databaseKind)

Determine the BLOB datatype of the database.

Returns:

the name of the BLOB datatype.

const func string: clobType (in dbCategory: databaseKind)

Determine the CBLOB datatype of the database.

Returns:

the name of the CBLOB datatype.