Re: Displaying text appears as hex data

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.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935