On 27-4-2012 12:03, AngelBlaZe wrote:

>
> for example
> a decimal(10,5) column
> would have using the query above:
> type = 16 And subtype = 2
> precision = 10
> scale = 5

Scale is a negative value, not positive (so a DECIMAL(10,5) has scale -5
(you can interpret it as: move the decimal 5 positions to the left).

> some common types:
> typemap(8) = ddTypes.aInteger
> typemap(37) = ddTypes.aString
> typemap(7) = ddTypes.aSmallInt
> typemap(16) = ddTypes.aDecimal
> typemap(12) = ddTypes.aDate
> typemap(35) = ddTypes.aDateTime
> typemap(261) = ddTypes.aByte

Table RDB$TYPES contains a mapping of ids to their type name (not just
for field types btw).
--
Mark Rotteveel