At 11:53 AM 5/05/2003 +0000, you wrote:

>Hello,
> I am new to firebird.
>I'm trying to migrate MS SQL database to firebird using sql2gdb.
>While converting it is giving me error
>
>"Unsupported data type BigInt(20) in column <column name> of table
><table name>"
>
>I dont understand whether firebird supports BigInt or not.

It supports a 64-bit integer type. In current releases (1.0xxxx) you need
to define it as NUMERIC(18,0). From 1.5 forward it will is aliased as
BigInt and Int64 for compatibility with some other RDBMSs.

>In
>documentation it has been specified that it does support BigInt. But
>it is still giving the problem. Is it like the utility (sql2gdb )
>i've downloaded, is of old version?

I expect the author will fill you in with details, but I'm guessing he has
updated the tool for FB 1.5 and, in his docs, might possibly have
overlooked backward compatibility with release 1.0xxxx...which is still the
current stable version of Firebird.

heLen