Re: select on bytea column returns hex encoded data instead of binary data

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: Ganesh Borse <bganesh05(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: select on bytea column returns hex encoded data instead of binary data
Date: 2012-02-22 14:07:15
Message-ID: 20120222140715.GF21114@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Feb 22, 2012 at 11:02:16AM +0800, Ganesh Borse wrote:
> Hi,
>
> I am new to postgresql.
>
> I've an application which displays the various binary files (like jpgs,
> xls, zips) stored in PostgrelSQL DB in bytea column.
>
> I inserted these files in bytea column in a table using hex encoding.
>
> But, when I try to access this column by executing (SQLExec) the query
> "select * from tablename;" from ODBC on Windows, the buffer contains the
> same hex encoded data.
>
> I am using SQL_C_BINARY data type for SQLBindCol() function.
>
> Can you please help me know, how can I retrieve the data stored in bytea
> columns in binary format?
>
> Thanks in advance for help and guidance.
>
> Best Regards,
> Ganesh

It sounds like ODBC is not using binary mode for the result retrieval but
is using text which results in either hex or escape encoding as you see.
You will need to find someone to help you with ODBC on Windows.

Regards,
Ken

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-02-22 15:13:16 Re: Export Control Classification Number (ECCN) Request
Previous Message ZXAEGAKKA001, ext 2012-02-22 11:16:06 Export Control Classification Number (ECCN) Request