Re: Support for U+0000 text

[Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>]

Hi Paul,

Go through below link hope this will help you.

https://www.postgresql.org/docs/9.0/multibyte.html

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

On Thu, Mar 7, 2019 at 8:36 AM Paul Draper <paulddraper@xxxxxxxxx> wrote:

When inserting the U+0000 (NULL) character, PostgreSQL errors:

ERROR: invalid byte sequence for encoding "UTF8": 0x00

I understand I could not use the text type, but given that this is a valid Unicode character, is there a reason this is not supported?