Seems that my code in InterBase Workbench, where I had to go to great
length to get the exact types :) - is reporting the same as isql... Is
that good? *g*

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

> > > You have used it all the time with IB/FB.
> > > :-)
> >
> > Ah-ha. So that's why IBconsole reports the field as numeric (in
> > metadata) whereas IB-SQL reports it as decimal.
>
> Have you tried isql?
>
> SQL> create table z(a decimal, b numeric);
> SQL> show table z;
> A DECIMAL(9, 0) Nullable
> B NUMERIC(9, 0) Nullable
> SQL>
>
> IBConsole is a thing partly based on isql, partly based on
> new bugs (on top
> of isql's known metadata extraction bugs) and may have
> evolved into its own
> code. Since the engine doesn't care too much about both
> types... it only put
> a value in system tables to tell the difference between
> numeric and decimal
> in version 6. In previous versions, even the engine can't
> tell which was the
> original declaration. You didn't say if your db was upgraded
> from v5 or was
> created in ib6.
>
> Against the same table shown above, IB_SQL says in the Source tab:
>
> CREATE TABLE Z (
> A INTEGER
> , B INTEGER
> )
>