Re: Support for \u0000?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew Byrne <mjw(dot)byrne(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Support for \u0000?
Date: 2017-07-19 18:30:54
Message-ID: 8239.1500489054@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthew Byrne <mjw(dot)byrne(at)gmail(dot)com> writes:
> Are there any plans to support \u0000 in JSONB and, relatedly, UTF code
> point 0 in TEXT?

No. It's basically never going to happen because of the widespread use
of C strings (nul-terminated strings) inside the backend. Making \0 a
legal member of strings would break all those internal APIs, requiring
touching far more code than anyone would want to do. It'd likely break
a great deal of client-side code as well.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2017-07-19 18:32:11 Re: Two-phase commit case studies
Previous Message Thom Brown 2017-07-19 18:29:56 Re: ~/.psqlrc file is ignored