Re: Displaying text appears as hex data

Thom Brown <thom(at)linux(dot)com> wrote:

> On 8 February 2011 18:45, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:
> > Michael <postgresql(at)encambio(dot)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°