--- In firebird-support@yahoogroups.com, 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.

Adam