A quick googling got the following
http://www.cpcug.org/user/clemenzi/technical/Databases/FieldTypes.html#F
irebird
Check Firebird section.

> -----Original Message-----
> From: Goutam Paruchuri [mailto:gparuchuri@...]
> Sent: Wednesday, December 29, 2004 1:53 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Stored Procedure Creator Problem
>
>
>
> Check the Quick start guide and look into section "Data types".
> The database conversions are also listed in the interbase manuals.
>
> - Goutam
>
> > -----Original Message-----
> > From: Leonardo Nakahara de Oliveira [mailto:okinawadin@...]
> > Sent: Wednesday, December 29, 2004 1:14 PM
> > To: firebird-support@yahoogroups.com
> > Subject: Re: [firebird-support] Stored Procedure Creator Problem
> >
> >
> >
> > Thanks Ivan,
> >
> > But that I know. Sorry, I think I've been a little not
> direct on
> > what I want here. Look, I need a table so I can make this
> > "translation".
> >
> > For example, I know that LONG(4) is the INTEGER in
> Firebird. But
> > what is Int64 (8,-4) just to be in one example only?
> >
> > I would like this table of translation so I can convert
> the types
> > I get with the SQL String to put it in my code.
> >
> > Thanks
> >
> > Ivan Prenosil wrote:
> >
> > >> But the problem is that the RDB$TYPE_NAME and
> > RDB$FIELD_LENGTH is
> > >>quite different from what is shown in the Firebird GUI I
> > use. There,
> > >>it shows varchar, integer, etc and when I run the SQL
> > Script it shows
> > >>varying, long, text, int64, etc.
> > >>
> > >> So, does anyone knows how to convert these types shown
> > when i run
> > >>the SQL Script to the types shown in the Firebird GUI?
> > >>
> > >>
> > >
> > >Yes, use CASE expression.
> > >
> > >SELECT
> > > CASE RDB$FIELD_TYPE WHEN 8 THEN 'INTEGER' WHEN 37 THEN
> > 'VARCHAR' ...
> > >END
> > >
> > >Ivan
> > >
> > >
> > >
> > >
> > >Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > --------------------~--> Make a clean sweep of pop-up ads.
> > Yahoo! Companion Toolbar.
> > Now with Pop-Up Blocker. Get it for free!
> > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> > --------------------------------------------------------------
> > ------~->
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> Confidentiality Notice
> The information contained in this e-mail is confidential and
> intended for use only by the person(s) or organization listed
> in the address. If you have received this communication in
> error, please contact the sender at O'Neil & Associates,
> Inc., immediately. Any copying, dissemination, or
> distribution of this communication, other than by the
> intended recipient, is strictly prohibited.
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $4.98 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>