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 по дате отправления: