Postgres Pro
Downloads
Home   >   mailing lists

Re: Support for U+0000 text - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Support for U+0000 text
Date
Msg-id CAGDYbUPyyh2Yay1Fkf7OCP0UL7rejsS11dLXnq3OWdUkfFNROw@mail.gmail.com
Whole thread Raw
In response to Support for U+0000 text  (Paul Draper <paulddraper@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> 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?

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Support for U+0000 text
Next
From: soumitra bhandary
Date:
Subject: Re: Installation of Postgres 10.0 and running application with HAwithout postgres user at OS