Subject Re: field type for "varchar" instead of "varying"
Author Adam
--- In, Lester Caine <lester@l...> wrote:
> opendevel11 wrote:
> > when i query field types, i saw that datatype is varying instead of
> > varhcar. How can i get it as varhcar? (same for long instead of
> > integer)
> This is a function of your client application!
> So what are you using to access Firebird?

It is actually how it is internally stored. Every tool will return the
same (iSQL included). The main point though is that the original
question was how do I get the field types. It does not take a brain
surgeon to map long-->integer, varying-->varchar etc.

If it is overly troubling, then you can use the case operator to
return something more convenient.