From: | Jeremy Buchmann <jeremy(at)wellsgaming(dot)com> |
---|---|
To: | James Orr <james(at)lrgmail(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: bytea on windows perl client |
Date: | 2002-07-17 17:17:55 |
Message-ID: | 2249A4CB-99A9-11D6-BECC-000502E740BA@wellsgaming.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Wednesday, July 17, 2002, at 10:06 AM, Joe Conway wrote:
> James Orr wrote:
> > OK, if I load the output into vi. The one from linux contains a
> bunch > of control characters etc. The one from windows seems to be
> all text
> > like so
> > ...
> >
>> \211PNG\015\012\000 and so on.
>
> This is the escaped output form of bytea. It seems that on linux the
> perl script is either using a binary cursor, or automagically
> unescaping the output, while on windows it isn't. I'm not sure why that
> would happen, but hopefully one of the perl gurus hanging around will
> chime in.
>
> Joe
James,
This may be a long shot, but try to binmode your output stream:
http://www.perldoc.com/perl5.6/pod/func/binmode.html
Let us know how it works.
--Jeremy
From | Date | Subject | |
---|---|---|---|
Next Message | James Orr | 2002-07-17 17:37:16 | Re: bytea on windows perl client |
Previous Message | Joe Conway | 2002-07-17 17:06:09 | Re: bytea on windows perl client |