> >In rdb$types the value for an INT64 field (ie QUAD) is 9.
> >
> >However a field defined as say numeric(18) (ie an INT64 field) has a

value

> >of 16 in rdb$fields.rdb$field_type.
>
> Oh, brilliant. QUAD is the VAX equivalent of INT64 (aka long long, Java
> long, etc.)
> Apparently they decided they needed a different value for reasons obscure.

I think I've heard someone say they wanted to remove VAX (or other machine)
related types...

Obscure enough? :)


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

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."