Обсуждение: Support for U+0000 text
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?
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
Hi Paul,
Go through below link hope this will help you.
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": 0x00I 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?