[Gambas-user] escape a picture

Jean-Yves F. Barbier 12ukwn at ...626...
Wed Nov 25 02:32:56 CET 2009


Benoît Minisini a écrit :
>> Benoît Minisini a écrit :
>>>> Hi,
>>>>
>>>> How can I escape a picture in order to insert it into a BYTEA
>>>> postgresql data field?
>>> Normally, if the postgresql field datatype is BYTEA, the gb.db component
>>> will see it as a blob.
>>>
>>> Let's suppose the field name is "Picture". You will do:
>>>
>>> MyResult!Picture = File.Load("/path/to/picture/file")
>>>
>>> Is it what you need?
>> NO, I need the opposite:
>> sqlQry = "SELECT MyTable_ins(MyPicture);
>>
>> where MyTable_ins(TEXT) is a stored PLPGSQL procedure that do
>> an indirect insert into myschema.mytable
>>
> 
> OK. So MyPicture must be a string including quoted binary data?
> 
> Alas there is no public access to the internal driver function that quotes 
> binary data for a blob. Do you want me to add it in Gambas 3? Something like 
> DB.QuoteBlob()?
 
What would also be nice would be direct conversions (ie: from String
to Picture and reverse)

-- 
 Assume a virtue, if you have it not.  -William Shakespeare




More information about the User mailing list