<html><head>
<meta http-equiv="Content-Type" content="text/html; CHARSET=UTF-8">
<meta name="GENERATOR" content="GtkHTML/4.8.4">
</head>
<body><div>Hi David.</div><div><br></div><div>Convert to bytes like this:</div><div>select id, fromip,toip,time_stamp, <b>msg::bytea</b> from sip_trace</div><div><br></div><div>Regards.</div><div><br></div><div>On Tue, 2015-11-24 at 16:59 +0100, david escartin wrote:</div><blockquote type="cite">
hello how are you?<br>
<br>
<br>
i have a problem using sipcapture module<br>
i'm writing in postgres database some sip messages but the msg field is stored ina strange format, <br>
<br>
\x5349502f322e30203438372052657175657374205465726d696e61746<br>
5640d0a5669613a205349502f322e302f5544502037392e3137302e36342e3136383a353038303b6272616e63683d7a39684734624b30583665375a70394e446533513b72656365697665643d37392e3137302e36342e3136383b72706f72743d353038300d0a5265636f72642d526f7574653a<br>
203c7369703a3139302e3136362e3233322e3139333a393236323b7472616e73706f72743d7564703b6c723e2c3c7369703a37392e3137302e36382e3138363b6c723b667461673d394448397648374435444653653b6469643d3639612e616437393e0d0a43616c6c2d49443a2033323666333<br>
037632d373138642d346164392d393234362d3333336432323466613439380d0a46726f6d3a2022313931373838393437363922203c7369703a31393137383839343736394037392e3137302e36342e3136383e3b7461673d394448397648374435444653650d0a546f3a203c7369703a313830<br>
39323935373838374037392e3137302e36382e3138363a353036303b757365723d70686f6e653e3b7461673d736263303830367974646c746f6c302d43432d33300d0a435365713a20383338353333383820494e564954450d0a5761726e696e673a203339392031302e31382e352e363420225<br>
353313230303031463135364c3934345b30303030305d2043616e63656c207265636569766564206f6e20696e697469616c20696e76697465220d0a436f6e74656e742d4c656e6774683a20300d0a0d0a<br>
<br>
do you know how to configure it to see it in ascii?<br>
<br>
thanks a lot and regards<br>
david escartin
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre></blockquote></body></html>