RE: [Firebird-net-provider] Byte arrays to and from FB

[<ma...@ga...>]

Okay, as Carlos stated, use a Blob.

You should then be able to save byte arrays to that Blob.

Something like:

CREATE TABLE MEMBERPICTURE (
    PICTUREID    INTEGER NOT NULL,
    MEMBERID     INTEGER NOT NULL,
    PICTUREDATA  BLOB SUB_TYPE 0 SEGMENT SIZE 80 NOT NULL
);

would be used to save images (converted to byte array)




>> maybe you could clarify what kind of data you want to store.
>
> I encrypt a credit card number to an array of 128 bytes and I want to be
> able to use this field in the where clause of a select statement
>
> Select name from t_transactions where cchash="an encrypted array of 128
> binary bytes"
>
>> If you want to store something you want to convert to a
>> string later on, why not using VARCHAR?
>> You will be probably best of with using UNICODE_FSS encoding,
>
> I don't want to make this a string. I just thought that if there is a
> problem sending an array to an SP a trick might be to convert it to some
> kind of string and pass it in as a string parameter but that would
> certainly be a workaround and it is only possible if I can find a
> stringformat wherto I can encode and decode an arbitary bytearray without
> any conversion issues.
>
> The problem is not really how to store it (I think), the problem is how to
> pass it from VB.NET to my firebird SP. Would it be easier to pass a BLOB
> than a byte array?
>
>
>> if you set the encoding correctly in the connection string,
>> the provider (and the .net framework) should handle all other
>> encoding issues...
>
> As far as I know I have no special settings in my .net project, I assume
> it is the default unicode both there and and in the provider. But I don't
> even know where to look for this so if you have pointers in that area it
> would be great to.
>
> Tim
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_idt12&alloc_id344&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>