On Wed, Sep 3, 2008 at 6:52 AM, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
> On Wed, Sep 3, 2008 at 3:08 AM, richard terry <rterry(at)gnumed(dot)net> wrote:
>> On Tue, 2 Sep 2008 10:40:59 pm Obe, Regina wrote:
>>> > =============================================
>>> > Hear your pain, this was all done on debian linux. binmode was a
>>> > I've done it with a bytea column like this
>>> > use DBI ;
>>> > use DBD::Pg qw(:pg_types); #Required for us to use the *bytea* column
>>> > I can't interpet the last line which (admittedly in another language)
>>> he says
>>> > is needed to use the bytea type.
>> I've made a little progress with some help from a gambas user but still
>> failing. Perhaps these two sample queries which stall will prompt someone to
>> guide me in the correct direction:
>> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
> The hint is probably helpful. See here:
> Both the documentation and the mailing lists are searchable, just in
> case you need more detail.
> Hope that helps,
>>> > Any further help appreciated.
>>> > Richard
>>> Unfortunately I don't know perl too well so the above is pretty cryptic
>>> to me too. From my cursory reading - seems the above just registers
>>> PostgreSQL datatypes with DBD.
>>> Which language are you programming in? My default encoding for my
>>> database is UTF-8, but I don't recall having to do anything special that
>>> wasn't already implicitly done by the driver I was using and I think the
>>> npgsql ADO.NET driver already takes care of registering the Pg bytea and
>>> other PG specific data types so my guess is you are not using .NET.
>>> Then again I don't do too much of storing images in the database.
>>> Seems then that whatever you are doing is not translating your data to
>>> bytea format correctly.
>>> Hope that helps,
>>> The substance of this message, including any attachments, may be
>>> confidential, legally privileged and/or exempt from disclosure
>>> pursuant to Massachusetts law. It is intended
>>> solely for the addressee. If you received this in error, please
>>> contact the sender and delete the material from any computer.
>> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>> To make changes to your subscription:
In response to
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2008-09-03 11:33:23|
|Subject: Re: telnet examples|
|Previous:||From: richard terry||Date: 2008-09-03 07:08:44|
|Subject: Re: How to save a image file in a postgres data field.|