Postgres Pro
Downloads
Home   >   mailing lists

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

From Paul Draper
Subject Support for U+0000 text
Date
Msg-id CAApx4VRT0-Zfz7AMzTi4e323tAP6pSbP7gCtKpS_nyFa+mnSxQ@mail.gmail.com
Whole thread Raw
Responses Re: Support for U+0000 text  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Support for U+0000 text  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view
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: Vijaykumar Jain
Date:
Subject: Re: [External] postgresql11.1 - stabilize partition pruning atexecution time
Next
From: Tom Lane
Date:
Subject: Re: Support for U+0000 text