ERROR: invalid byte sequence for encoding UTF8: 0x00

From: Kiran K V <kirankv(dot)1982(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ERROR: invalid byte sequence for encoding UTF8: 0x00
Date: 2024-01-09 12:18:23
Message-ID: CAGv0ivqrbg6qphPbU-YyKuAb31dVGRWrZC_R8Zdhj3TWbiB=GA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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 ?

Please advise. Thank you very much.

Regards,
Kiran

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jian he 2024-01-09 14:38:00 Re: postgresql custom variable in pg_settings table
Previous Message Paul van der Linden 2024-01-09 10:28:42 Order of multicolumn gist index