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.