Re: Request for help on retrieving binary data from bytea column using ODBC calls

Hi,

I am using the following PostgreSQL ODBC Windows driver:

PostgreSQL 64bit 8.03.04.00 PSQLODBC_X64_RELEASE.DLL 8/3/2009 -- the one
which got installed with PostgreSQL 9.0 server that I downloaded from
PostgreSQL website.

Thanks,

On Mon, Feb 27, 2012 at 4:30 PM, Ganesh Borse <bganesh05(at)gmail(dot)com> wrote:

> Log is as below:
> Â
> cf11e0a1b11ae1000000000000000000000000000000003b000300feff0900060000000000000000000000010000006a00000000000000001000006700000001000000feffffff0000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
>
> Memory dump in VC++ debug window:
> Address Hex Value
> 0x0000000000367850 a0 63 66 31 31 65 30 61 31 62 31 31 61 65 31 30 30 30
> 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30
> 30 30 30 30 33 62 30 30 30 33 30 30 66 65
> cf11e0a1b11ae1000000000000000000000000000000003b000300fe
> 0x0000000000367889 66 66 30 39 30 30 30 36 30 30 30 30 30 30 30 30 30 30
> 30 30 30 30 30 30 30 30 30 30 30 30 30 31 30 30 30 30 30 30 36 61 30 30 30
> 30 30 30 30 30 30 30 30 30 30 30 30 30 31
> ff0900060000000000000000000000010000006a00000000000000001
> 0x00000000003678C2 30 30 30 30 30 36 37 30 30 30 30 30 30 30 31 30 30 30
> 30 30 30 66 65 66 66 66 66 66 66 30 30 30 30 30 30 30 30 30 30 30 30 30 30
> 30 30 66 66 66 66 66 66 66 66 66 66 66 66
> 000006700000001000000feffffff0000000000000000ffffffffffff
> 0x00000000003678FB 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66
> 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66
> 66 66 66 66 66 66 66 66 66 66 66 66 66 66
> fffffffffffffffffffffffffffffffffffffffffffffffffffffffff
> 0x0000000000367934 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66
> 66 66 66 66 66 66 66 66 66 66 66 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> fffffffffffffffffffffffffffff............................
>
>
> On Sat, Feb 25, 2012 at 5:47 AM, Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> wrote:
>
>> (2012/02/24 18:56), Ganesh Borse wrote:
>>
>>> Hi,
>>>
>>> I used the steps same as outlined below:
>>>
>>> xxd -p /home/user/myimage.png | tr -d '\n' > /tmp/image.hex
>>> DELETE FROM hexdump; -- hexdump table is: -- CREATE TABLE hexdump
>>> (hex text);
>>> COPY hexdump FROM '/tmp/image.hex';
>>> UPDATE users SET image= (SELECT decode(hex, 'hex') FROM hexdump
>>> LIMIT 1) where id=15489
>>>
>>> Is this the correct way of inserting binary data into bytea column?
>>>
>>> When I fetch a small part of this column, I get output as below:
>>>
>>> select substring(smallblob,0,64) from longdata where blobi d=1;
>>>
>>> \**xd0cf11e0a1b11ae10000000000000**00000000000000000003b000300fef**f09000600000000000
>>> 00000000000010000006a000000000**0000000100000670000 (1 row)
>>>
>>
>> Looks OK to me.
>> Could you send me directly the Mylog output of the simple test case?
>>
>> regards,
>> Hiroshi Inoue
>>
>
>