Unicode error with \u0000 on COPY of large JSON file into Postgres
In a (perhaps) similar case I had been confronted with \u0000 in a string I needed to process as JSON. The follow replace worked for me:

regexp_replace(stringWithNull, '\\u0000', '', 'g')


Hope this helps.