How can I read a bytea value in a sql result set?

> Dear list,
>
> How can I read a bytea value in a sql result set?
>
> Postgres returns a bytea which only contains a string.
>
> I would like to parse the field in the result set. But I cannot get to
> it with xs:string.
>
> Using oxf:base64Binary gives me the non-string value (I think this is
> the binary representation of the bytea object).

> Michiel,
>
> I don't know anything about bytea. The SQL processor is able to handle
> binary data as BLOBs though. But I would think that this would require
> fixing up some code in QueryInterpreter.java.
>
> -Erik
>
> Michiel Roos wrote:
>> Dear list,
>>
>> How can I read a bytea value in a sql result set?
>>
>> Postgres returns a bytea which only contains a string.
>>
>> I would like to parse the field in the result set. But I cannot get
>> to it with xs:string.
>>
>> Using oxf:base64Binary gives me the non-string value (I think this is
>> the binary representation of the bytea object)

> Dear list,
>
> This issue has been cricumvented. We are no longer attempting to read
> binary data.
>
> The whole thing boils down to a configuration error because of which the
> field type in postgres became a bytea field. It only stores text in
> reality.
>
> A postgres function has been written to only retrieve the value we
> really want.
>
> Thanks for your reply though Erik. I figured that something along those
> lines would have to be done as I could not find any references to orbeon
> / bytea.
>
> Cheers,
>
>
> Michiel Roos
>
> Erik Bruchez wrote:
>> Michiel,
>>
>> I don't know anything about bytea. The SQL processor is able to handle
>> binary data as BLOBs though. But I would think that this would require
>> fixing up some code in QueryInterpreter.java.
>>
>> -Erik
>>
>> Michiel Roos wrote:
>>> Dear list,
>>>
>>> How can I read a bytea value in a sql result set?
>>>
>>> Postgres returns a bytea which only contains a string.
>>>
>>> I would like to parse the field in the result set. But I cannot get
>>> to it with xs:string.
>>>
>>> Using oxf:base64Binary gives me the non-string value (I think this is
>>> the binary representation of the bytea object)
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the [hidden email] mailing list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws