Re: bytea on windows perl client - Mailing list pgsql-interfaces

From Jeremy Buchmann
Subject Re: bytea on windows perl client
Date
Msg-id 2249A4CB-99A9-11D6-BECC-000502E740BA@wellsgaming.com
Whole thread Raw
In response to Re: bytea on windows perl client  (Joe Conway <mail@joeconway.com>)
Responses Re: bytea on windows perl client
List 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



pgsql-interfaces by date:

Previous
From: Joe Conway
Date:
Subject: Re: bytea on windows perl client
Next
From: James Orr
Date:
Subject: Re: bytea on windows perl client