Hi, Have you checked this? https://stackoverflow.com/questions/44813386/mysqls-hex-and-unhex-equivalent-in-postgres
-- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company <http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi* <http://www.linkedin.com/in/asheshvashi> On Sun, Aug 9, 2020 at 11:42 AM Condor <con...@stz-bg.com> wrote: > > Hello, > > how I can reproduce MySQL binary to PosgreSQL and use follow > functionality in PG. > > On mysql I have table with 3 fields: > > CREATE TABLE table ( > user_id int, > user_info binary(4), > user_data binary(16) > ); > > then I use them for example: > > UPDATE table set user_info = CHAR(0, 2, 0, 0), user_data = CHAR(123, 1, > 0, 2) WHERE user_id = 1; > > select and insert them as: > > SELECT HEX(user_info) AS user_info, HEX(user_data) AS user_data FROM > table; > INSERT INTO table (user_info, user_data) VALUES > (UNHEX(hexdata_commng_from_app), UNHEX(hexdata_commng_from_app)); > > I check PG does not have functions HEX and UNHEX. Some one can help a > little ? > > Regards, > HS > > >