Re: Displaying text appears as hex data

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

> On 8 February 2011 19:28, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:
> > 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.
>
> I asked Michael to confirm the column type of msg and it turned out to
> be text. No mention of the lo contrib module, so I guess that may
> possibly come into play, but I wouldn't know about that.

Okay, you are right, i haven't read the other sub-thread, sorry.

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°