Subject Re: [firebird-support] Int64 Field Type
Author Helen Borrie
Slim/Paul
At 12:19 AM 20/06/2003 +0200, you wrote:
>Hi Slim,
>
> > Can any one help I was under the impression that FB implemented the
> > Int64 field type.
> > Is this true and if so how is it declared.
>
>Yes, and it's simply called INT64, like in:

Actually, it's called BigInt, which is ugly, but it's standard-conformant. :-(


> create table MyTable (
> big_id int64,

big_id BigInt,

> charfield char( 3 ),
> ...,
> ...
> );

That's on a 1.5 server. It's not implemented in 1.0.x, so the declaration
is NUMERIC(18,0) there - again with the Dialect restriction.

heLen