>>>> 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.

I think sub_type got filled in for new columns in Fb 1.5 and higher or so...

The INT64 internal type is supported since IB 6.

I'm unsure when this made it into Firebird as BIGINT.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com