Daniel Pittman <[EMAIL PROTECTED]> writes:
[ahem. wrong keystroke, so the rest of my message follows]
> Sean Davis <[EMAIL PROTECTED]> writes:
>> On 3/22/06 2:39 PM, "Sean Davis" <[EMAIL PROTECTED]> wrote:
>>> On 3/22/06 1:36 PM, "John Siracusa" <[EMAIL PROTECTED]> wrote:
>>>> On 3/22/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>>>>> Why is the type for "contents" a scalar?
>>>>
>>>> Because that's the default when there is not a more specific RDBO
>>>> column type mapped to whatever DBI returns for the column type.
>>>>
>>>>> I would like to store binary data in that column, which I can do
>>>>> with straight DBI, but it seems I have to specify the bind_type as
>>>>> DBD::Pg::PG_BYTEA.
>>>>
>>>> Is there no other way to use a bytea column using DBI? For example,
>>>> will it accept a base64 encoded string or something? If not, then
>>>> RDBO will have to be changed to add support for explicit bind types
>>>> for individual column values.
>>
>> Just tried it and Base64 encoding works fine. I can presumably
>> inflate and deflate within my RDBO class. Thanks for the idea.
>
> Presumably that works because nothing in the Base64 string requires
> BYTEA encoding when you insert it.[1]
>
> On the negative side, you just expanded the storage consumed in your
> BYTEA column by twenty-five percent, by not storing direct binary data
> in there.
Unless I am mistaken, then, without the explicit type binding for the
column there isn't much point in using BYTEA compared to a TEXT column
with base64 stored in it.
Daniel
> Footnotes:
> [1] Assuming that my understanding of the column type is right, and that
> it hasn't changed in newer releases than 8.0
--
Digital Infrastructure Solutions -- making IT simple, stable and secure
Phone: 0401 155 707 email: [EMAIL PROTECTED]
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
