Re: [Firebird-net-provider] Convert BLOB to string

[Martin <mc...@we...>]

Thanks for that, I am a little confusesd.
I'm not sure what the sub type has to do with it. Does this mean that I can
retrive the data directly if  it has a subtype of text??

I have never used the "Encoding" classes before. Do these classes belong to
.net framework or firebirdsql.
I would appreciate knowing the full namespace of the classes to use then I
can start looking through the documentation.
Any pointers on articles that may be helpful in doing such a thing is
appreciated  (it is totally new to me.)



just for back ground this is the create statement for my table

CREATE TABLE EE_SP_NAME (
    ID                   PK_ID NOT NULL,
    PROCEDURE_NAME       VC80 NOT NULL,
    DISPLAY_TEXT         VC80 NOT NULL,
    DISPLAY_DESCRIPTION  BLOB_TEXT_DATA NOT NULL,
    CREATED              TIMESTAMP_NOW NOT NULL
);

the definition of the blob text domain is

BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE

cheers

martin



"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > I am retrieving a BLOB field from a firebird db via .net provider 1.5
> >
> > I am using ExecuteScalar() to get the first single result from execution
of
> > the stored procudure I am trying to retrieve the value like so
>
> It's a blob field with subtype text ?? if not the provider will return
> an array of bytes and you will need to convert it to an string using the
> Encoding classes.
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>