Subject Re: [IB-Conversions] Unsupported data type BigInt
Author Daniel Rail
Hi,

At May 5, 2003, 08:53, gh_patil 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. 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?

Which version of Firebird are you using?

BIGINT data type has been added in FB 1.5. It's true that FB 1.0 does
support an equivalent to MS-SQL's BIGINT, and it's NUMERIC(18,0).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)