Subject Re: [firebird-support] Dialect 3, BigInt
Author Helen Borrie
At 02:00 AM 10/10/2005 +0800, you wrote:
>I'm running Firebird 1.0.3, Windows XP.
>I tried to create a BigInt column, but failed. The following is taken
>from isql.
>SQL> show sql dialect;
> Client SQL dialect is set to: 3 and database SQL dialect is: 3
>SQL> create table test (id BIGINT);
>Statement failed, SQLCODE = -607
>Dynamic SQL Error
>-SQL error code = -607
>-Invalid command
>-Specified domain or source column BIGINT does not exist
>Is BIGINT supported in Firebird 1.0.3 or do I need to run 1.5.x ?

The token "BIGINT" didn't enter the language until 1.5. In v.1.0.3 you
need to define the column as numeric(18,0).