I tested this patch all. Now issue is fixed.
Also exist other way to fix this. Need to use

SELECT convert_from(body,'UTF-8') FROM presentity;

in SQL request to PostgreSQL server instreat of

SELECT body FROM presentity;

Example

pg1:~$ psql kamailio
psql (9.6.3)
Type "help" for help.

kamailio=# CREATE TABLE blob_table (blob bytea);
CREATE TABLE
kamailio=# INSERT INTO blob_table VALUES ('Kamailio');
INSERT 0 1
kamailio=# SELECT blob,  convert_from(blob,'UTF-8') FROM blob_table;
        blob        | convert_from 
--------------------+--------------
 \x4b616d61696c696f | Kamailio
(1 row)

Second way is more elegant but i do not know hot to need change source code.

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.