Re: Need help how to reproduce MySQL binary to PosgreSQL

On Sun, 9 Aug 2020 at 12:49, Condor wrote: > Yea, I checked it, but because is 3 years old solution I expect these > functions to be implemented long ago and just have another names or to > have similar functions that do the same functionality. It's seems not, > Okay will use the solution from

Re: Need help how to reproduce MySQL binary to PosgreSQL

On 09-08-2020 09:20, Ashesh Vashi wrote: 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 [1] _http://www.linkedin.com/in/asheshvashi_ [2]

Re: Need help how to reproduce MySQL binary to PosgreSQL

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

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),