Horton

Mention invalid null byte sequence

The Post Office <noreply@postgresql.org>

View thread View on postgr.es
From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: bugs-postgresql@antipoul.fr
Date: 2020-12-05T21:58:49Z
Lists: pgsql-docs 
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/datatype-character.html
Description:

I discovered accidentally that PostgreSQL doesn't accept null byte in text
type. It seems that Oracle does (see
https://www.postgresql.org/message-id/de752e01-f36c-821e-9181-cfba78c0fbc8%40propaas.com)
and SQLite does it too.

So it should written in the character type that null byte are not accepted,
it would make like easier to migrate to PostgreSQL :)

Commits

  1. Doc: explain that the string types can't store \0 (ASCII NUL).