| Subject | Re: [firebird-support] difference bigint / numeric in rdb$fields.rdb$field_type (both have value 16)!? |
|---|---|
| Author | Martijn Tonies |
| Post date | 2009-02-11T09:55:37Z |
> crizoo4712 wrote:This, however, is not filled in for older databases/Firebird versions.
>> 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
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