Support for U+0000 text

From: Paul Draper <paulddraper(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Support for U+0000 text
Date: 2019-03-07 03:06:10
Message-ID: CAApx4VRT0-Zfz7AMzTi4e323tAP6pSbP7gCtKpS_nyFa+mnSxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2019-03-07 03:40:31 Re: Support for U+0000 text
Previous Message Vijaykumar Jain 2019-03-04 18:38:16 Re: [External] postgresql11.1 - stabilize partition pruning at execution time