Re: ERROR: invalid byte sequence for encoding UTF8: 0x00 - Mailing list pgsql-general

From Laurenz Albe
Subject Re: ERROR: invalid byte sequence for encoding UTF8: 0x00
Date
Msg-id 2f91c83c9529ad677091b3c167292eb5967bbb6e.camel@cybertec.at
Whole thread Raw
In response to ERROR: invalid byte sequence for encoding UTF8: 0x00  (Kiran K V <kirankv.1982@gmail.com>)
Responses Re: ERROR: invalid byte sequence for encoding UTF8: 0x00  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, 2024-01-09 at 17:48 +0530, Kiran K V wrote:
> I have a table with bytea column and trying to load the data using copy command.
> But Copy command is failing with
> "ERROR: invalid byte sequence for encoding UTF8: 0x00.
> Why postgresql is failing to load when data contains 0x00.
> How to resolve this error ? any workaround to load the data with 0x00 values ?

This is not about loading data into a "bytea", but into a "text", "varchar" or
"char" column.  Check again.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: jian he
Date:
Subject: Re: postgresql custom variable in pg_settings table
Next
From: Tom Lane
Date:
Subject: Re: ERROR: invalid byte sequence for encoding UTF8: 0x00