Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error while writing data

Error while writing data

From
Gaurav Anand
Date:
Hi Team,

Can you help me with this error

ERROR: invalid byte sequence for encoding "UTF8": 0x00 Call getNextException to see other errors in the batch.

Thanks.

Regards,
Gaurav Anand

logo

This communication is confidential and subject to and governed by Saama’s Electronic Communications Disclaimer.

 

Re: Error while writing data

From
"David G. Johnston"
Date:


On Fri, Oct 21, 2022 at 5:07 AM Gaurav Anand <gaurav.anand@saama.com> wrote:
Hi Team,

Can you help me with this error

ERROR: invalid byte sequence for encoding "UTF8": 0x00 Call getNextException to see other errors in the batch.

PostgreSQL does not permit storing the NUL character in a text data type field.

David J.
 

Re: Error while writing data

From
jian he
Date:


On Fri, Oct 21, 2022 at 5:38 PM Gaurav Anand <gaurav.anand@saama.com> wrote:
Hi Team,

Can you help me with this error

ERROR: invalid byte sequence for encoding "UTF8": 0x00 Call getNextException to see other errors in the batch.

Thanks.

Regards,
Gaurav Anand

logo

This communication is confidential and subject to and governed by Saama’s Electronic Communications Disclaimer.

 


Just found out about this hot post[0]. 


[0]: https://stackoverflow.com/questions/1347646/postgres-error-on-insert-error-invalid-byte-sequence-for-encoding-utf8-0x0

--
 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian