Re: Problem inserting binary data in bytea column of UTF-8 database

Hello Alexey,

You are right!

Double quote disapeared in my C++ program (because not properly escaped)
and I performed copy paste of C++ generated SQL query for further tests
without realising that there was a missing backslash.

Thanks for your help,
Brice

2018-07-05 15:48 GMT+02:00 Alexey Bashtanov <bashtanov(at)imap(dot)cc>:

> Hi Brice,
>
> On 03/07/18 05:28, Brice André wrote:
>
>> insert into test (test) values (E'\xC744'::bytea);
>>
>
> I think double backslash needs to be used.
> See https://www.postgresql.org/docs/current/static/datatype-bina
> ry.html#id-1.5.7.12.9
>
> Best,
> Alex
>