Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 22:27, Michael wrote: > > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 February 2011 19:28, Andreas Kretschmer >>wrote: >>> Thom Brown wrote: On 8 February 2011 18:45, Andreas Kretschmer wrote: > Michael wrote: >> I'm trying to view text data stored b

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 19:28, Andreas Kretschmer wrote: >> Thom Brown wrote: >>> On 8 February 2011 18:45, Andreas Kretschmer >>> wrote: Michael wrote: > I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest) > as BLOB and Postgr

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Andreas Kretschmer
Thom Brown wrote: > On 8 February 2011 19:28, Andreas Kretschmer > wrote: > > Thom Brown wrote: > > > >> On 8 February 2011 18:45, Andreas Kretschmer > >> wrote: > >> > Michael wrote: > >> > > >> >> > >> >> Hello list, > >> >> > >> >> I'm trying to view text data stored by OpenSIPS 1.6.4 (t

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 19:28, Andreas Kretschmer wrote: > Thom Brown wrote: > >> On 8 February 2011 18:45, Andreas Kretschmer >> wrote: >> > Michael wrote: >> > >> >> >> >> Hello list, >> >> >> >> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest) >> >> as BLOB and PostgreSQL is di

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Andreas Kretschmer
Thom Brown wrote: > On 8 February 2011 18:45, Andreas Kretschmer > wrote: > > Michael 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: > >

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 18:45, Andreas Kretschmer wrote: > Michael 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: >> >> $ TERM=vt100 /pfx/bin/psql opensips opensips >> psql (9.0.2) >>

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Andreas Kretschmer
Michael 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: > > $ TERM=vt100 /pfx/bin/psql opensips opensips > psql (9.0.2) > Type "help" for help. > > opensips=> select * from sip_trace

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Thom, On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 14:30, Michael wrote: >> On Tues., Feb 08, 2011, Thom Brown wrote: >>>On 8 February 2011 13:43, Thom Brown wrote: On 8 February 2011 13:19, Michael wrote: > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 Feb

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 14:30, Michael wrote: > > Hello Thom, > > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 February 2011 13:43, Thom Brown wrote: >>> On 8 February 2011 13:19, Michael wrote: On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 12:45, Michael wrote: >> On T

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Thom, On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 13:43, Thom Brown wrote: >> On 8 February 2011 13:19, Michael wrote: >>> On Tues., Feb 08, 2011, Thom Brown wrote: On 8 February 2011 12:45, Michael wrote: > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 Febr

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Thom, On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 13:43, Thom Brown wrote: >> On 8 February 2011 13:19, Michael wrote: >>> On Tues., Feb 08, 2011, Thom Brown wrote: On 8 February 2011 12:45, Michael wrote: > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 Febr

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Karsten, On Tues., Feb 08, 2011, Karsten Hilbert wrote: >On Tue, Feb 08, 2011 at 02:19:49PM +0100, Michael wrote: The arrow in the last line indicates that 'convert_from' is not correctly parsed. >>>My understanding was that your msg column was of type bytea. Is this >>>not

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 13:43, Thom Brown wrote: > On 8 February 2011 13:19, Michael wrote: >> >> Hello Thom, >> >> On Tues., Feb 08, 2011, Thom Brown wrote: >>>On 8 February 2011 12:45, Michael wrote: On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 10:39, Michael wrote: >>

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 13:19, Michael wrote: > > Hello Thom, > > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 February 2011 12:45, Michael wrote: >>> On Tues., Feb 08, 2011, Thom Brown wrote: On 8 February 2011 10:39, Michael wrote: > opensips=> select * from sip_trace; >  id | time_s

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Karsten Hilbert
On Tue, Feb 08, 2011 at 02:19:49PM +0100, Michael wrote: > >> The arrow in the last line indicates that 'convert_from' is not > >> correctly parsed. > >> > >My understanding was that your msg column was of type bytea. Is this > >not the case? Or is it a different column which needs converting? >

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Thom, On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 12:45, Michael wrote: >> On Tues., Feb 08, 2011, Thom Brown wrote: >>>On 8 February 2011 10:39, Michael wrote: opensips=> select * from sip_trace;  id | time_stamp | callid | traced_user | msg | method | ...

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 12:45, Michael wrote: > > Hello Thom, > > I sent this accidentally to you directly, here's a copy for the > list as well. > > On Tues., Feb 08, 2011, Thom Brown wrote: >>On 8 February 2011 10:39, Michael wrote: >>> opensips=> select * from sip_trace; >>>  id | time_stamp | calli

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Thom, I sent this accidentally to you directly, here's a copy for the list as well. On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 10:39, Michael wrote: >> opensips=> select * from sip_trace; >>  id | time_stamp | callid | traced_user | msg | method | ... >>  1234 | 2011-02-

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
Hello Karsten, On Tues., Feb 08, 2011, Karsten Hilbert wrote: >On 8 February 2011 10:39, Michael wrote: >> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest) >> as BLOB > >I take it you mean BYTEA. > That's probably correct, yes. >> and PostgreSQL is displaying it in hex format l

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Karsten Hilbert
On Tue, Feb 08, 2011 at 11:39:04AM +0100, Michael wrote: > I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest) > as BLOB I take it you mean BYTEA. > and PostgreSQL is displaying it in hex format like so: > > $ TERM=vt100 /pfx/bin/psql opensips opensips > psql (9.0.2) > Type "help

Re: [GENERAL] Displaying text appears as hex data

2011-02-08 Thread Thom Brown
On 8 February 2011 10:39, Michael 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: > > $ TERM=vt100 /pfx/bin/psql opensips opensips > psql (9.0.2) > Type "help" for help. > > opensips=> se

[GENERAL] Displaying text appears as hex data

2011-02-08 Thread Michael
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: $ TERM=vt100 /pfx/bin/psql opensips opensips psql (9.0.2) Type "help" for help. opensips=> select * from sip_trace; id | time_stamp | callid | traced_us