Displaying text appears as hex data
От | Michael |
---|---|
Тема | Displaying text appears as hex data |
Дата | |
Msg-id | 20110208103904.GB7086@debut.europalab.com обсуждение исходный текст |
Ответы |
Re: Displaying text appears as hex data
Re: Displaying text appears as hex data Re: Displaying text appears as hex data |
Список | pgsql-general |
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_user | msg | method | ... 1234 | 2011-02-03 | ... | | \x494e56495445207369703a... Others have said that when they use MySQL, the exact SQL command as above results in ASCII text rather than hexadecimal, and this is my goal as well. How can I accomplish this in the easiest way? Is there something in the PostgreSQL source tree that I should change, for example hacking in: src/backend/utils/mb/conversion_procs Thanks alot, Michael
В списке pgsql-general по дате отправления: