Re: Displaying text appears as hex data - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Displaying text appears as hex data
Date
Msg-id 20110208192845.GA6789@tux
Whole thread Raw
In response to Re: Displaying text appears as hex data  (Thom Brown <thom@linux.com>)
Responses Re: Displaying text appears as hex data
List pgsql-general
Thom Brown <thom@linux.com> wrote:

> On 8 February 2011 18:45, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
> > Michael <postgresql@encambio.com> wrote:
> >
> >>
> >> Hello list,
> >>
> >> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> >> as BLOB and PostgreSQL is displaying it in hex format like so:
        ^^^^

> >
> > set:
> >
> > bytea_output = 'escape'
>
> That won't help as the msg column is actually text... for some reason.

Are you sure? I know that problem from DRUPAL with 9.0.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Permission denied error - best way to fix?
Next
From: Thom Brown
Date:
Subject: Re: Displaying text appears as hex data