Re: Support for U+0000 text

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: Paul Draper <paulddraper(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Support for U+0000 text
Date: 2019-03-07 03:59:46
Message-ID: CAGDYbUPyyh2Yay1Fkf7OCP0UL7rejsS11dLXnq3OWdUkfFNROw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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?
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message soumitra bhandary 2019-03-07 04:38:33 Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
Previous Message Tom Lane 2019-03-07 03:40:31 Re: Support for U+0000 text