Re: Need help how to reproduce MySQL binary to PosgreSQL

2020-08-08 Thread Ashesh Vashi
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.linkedin.com/in/asheshvashi*

Need help how to reproduce MySQL binary to PosgreSQL

2020-08-08 Thread Condor
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), us