Subject Re: [firebird-support] Re: Storing a byte array in Firebird
Author Mark Rotteveel
On 27-10-2019 00:25, blackfalconsoftware@... [firebird-support]
wrote:
> I have found what I needed.
>
> Sorry for the bother...
>
> I was having trouble finding a way top convert the array into a string,
> which led me to believe I would have to store it in array format.
>
> I eventually found the correct solution after going through several
> incorrect ones. I couldn't remember that all I needed was to use the
> Base64 conversion...

There is no need to do that. Type CHAR/VARCHAR with character set OCTETS
is what you need.

Storing binary data encoded in base64 will consume 1/3 more bytes than
necessary.

Mark
--
Mark Rotteveel