Cristoph

You can try

select cast(fieldname as varchar(250) character set octets)
from table

and it returns for example
4669726562697264 for a string "Firebird"

is it what you want ?

Regards

Alexandre

--- In firebird-support@yahoogroups.com, Nando Dessena <nando@...> wrote:
>
> Cristoph
>
> c> is there something like select dump(<fieldname>) from ..
> c> like in oracle?
>
> no, but when you select something Firebird returns you the metadata
> info in a structure called a SQLDA. This is surfaced differently
> depending on your interface layer, which you don't mention.
>
> You can get metadata info also by querying RDB$RELATIONS,
> RDB$RELATION_FIELDS and REDB$FIELDS.
>
> You might want to explain what you're trying to do, so that we can
> suggest the Firebird way of doing it.
>
> Ciao
> --
> Nando Dessena
> ======================================================
> I support Firebird, I am a Firebird Foundation member!
> Join today at http://www.firebirdsql.org/ff/foundation
> ======================================================
>