Are there any plans to support \u0000 in JSONB and, relatedly, UTF code point 0 in TEXT? To the best of my knowledge \u0000 is valid in JSON and code point 0 is valid in UTF-8 but Postgres rejects both, which severely limits its usefulness in many cases.
I am currently working around the issue by using the JSON type, which allows \u0000 to be stored, but this is far from ideal because it can't be cast to TEXT or JSONB and can't even be accessed:
mydb=# select '{"thing":"\u0000"}'::json->>'thing';
ERROR: unsupported Unicode escape sequence
DETAIL: \u0000 cannot be converted to text.
CONTEXT: JSON data, line 1: {"thing":...
Regards,
Matt