Subject Re: [ib-support] Re: [IB-Conversions] Porting from mysql to firebird
Author Ulrich_Groffy
Hello,

what is the difference between NUMERIC(18,0) and the FB 1.5 type BIGINT?

Best regards Ulrich

>
> There is no auto-increment type. Declare the column as a NUMERIC(18,0)
> type which is the 64-bit integer and use a generator to populate it. To
> make the engine automatically insert the next value of the generator each
> time a row is inserted, write a Before Insert trigger, e.g.
> CREATE GENERATOR GEN_ATABLE;
>