Martijn Tonies wrote:

>> crizoo4712 wrote:
>>> how can I recognize the difference between bigint and numeric() in
>>> rdb$fields.rdb$field_type?
>> In field_type you can't. It's stored in rdb$field_sub_type
>>
>> DECIMAL sub_type=2
>> NUMERIC sub_type=1
>> BIGINT sub_type=0
>> --
>> Milan Babuskov
>
> This, however, is not filled in for older databases/Firebird versions.

Older versions of Firebird don't support BIGINT anyway. Or maybe there
is some special case I'm unaware of? Looking at FR code it does say that
BIGINT should be used only when subtype=0 and precision=0, so you're
probably right.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com