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

Paul Draper <paulddraper@gmail.com> writes:
> 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?

Yes: internally, the text representation of all data types is a C string,
ie a \0-terminated string.  That's not something that's practical to
change.

            regards, tom lane