From: | <gpd(at)gpdnet(dot)co(dot)uk> |
---|---|
To: | <brice(at)famille-andre(dot)be>, <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: BUG #15261: Insert binary data in bytea rejected due to UTF-8 encoding errors |
Date: | 2018-07-04 11:13:39 |
Message-ID: | 349f01d41388$0f9af300$2ed0d900$@gpdnet.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>
> I have a database using UTF-8 encoding and, in which I have bytea columns
> where I store binary data.
>
> I followed instructions in
> https://www.postgresql.org/docs/9.6/static/datatype-binary.html to encode
> the binary data, but it is still rejected due to a "ERROR: invalid byte sequence
> for encoding "UTF8"" error.
>
> I wrote a small script that reproduces the problem in a small database. The
> script can be simply copy-pasted in a psql session:
>
> CREATE DATABASE test WITH TEMPLATE = template0 ENCODING = 'UTF8'
> LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8'; \connect test;
> CREATE TABLE test (test bytea); insert into test (test) values
> (E'\xC744'::bytea);
>
You'll notice in the link you provided for your example that you need an extra backslash ('\') for the escape format you are using.
Regards,
Gary.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2018-07-04 12:50:12 | Re: NOTIFY does not work as expected |
Previous Message | PG Bug reporting form | 2018-07-04 11:02:26 | BUG #15261: Insert binary data in bytea rejected due to UTF-8 encoding errors |