Re: Displaying text appears as hex data

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Displaying text appears as hex data
Дата
Msg-id 20110208204811.GA9764@tux
обсуждение исходный текст
Ответ на Re: Displaying text appears as hex data  (Thom Brown <thom@linux.com>)
Список pgsql-general
Thom Brown <thom@linux.com> wrote:

> On 8 February 2011 19:28, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
> > 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.
>
> 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°

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Permission denied error - best way to fix?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: plperl.dll on windows with postgresql 9.0.3