From: | Michael <postgresql(at)encambio(dot)com> |
---|---|
To: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Displaying text appears as hex data |
Date: | 2011-02-08 22:27:59 |
Message-ID: | 20110208222759.GB10086@debut.europalab.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tues., Feb 08, 2011, Thom Brown 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:
>>>>> 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.
>
By the way if the data is indeed properly stored as text in the
database, why isn't it printed as text when using a plain SELECT?
The text data is printed as binary hex instead, what?!
...but the conversion works of course.
Regards,
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2011-02-08 22:36:10 | Re: Displaying text appears as hex data |
Previous Message | Albert | 2011-02-08 22:06:29 | Recovery with WAL |