Re: Need help how to reproduce MySQL binary to PosgreSQL

From: Condor <condor(at)stz-bg(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Need help how to reproduce MySQL binary to PosgreSQL
Date: 2020-08-09 11:49:49
Message-ID: 1f30d97d75f41e09f64a23a5e49dfa1f@stz-bg.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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]
>
> On Sun, Aug 9, 2020 at 11:42 AM Condor <condor(at)stz-bg(dot)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
>
>

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 sof.

Regards,
HS

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2020-08-09 12:41:32 Re: Need help how to reproduce MySQL binary to PosgreSQL
Previous Message Ashesh Vashi 2020-08-09 06:20:13 Re: Need help how to reproduce MySQL binary to PosgreSQL