ERROR: unsupported Unicode escape sequence - in JSON-type column

From: Jan Bilek <jan(dot)bilek(at)eftlab(dot)com(dot)au>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: unsupported Unicode escape sequence - in JSON-type column
Date: 2023-02-27 06:28:37
Message-ID: 43a45b6e-08f6-b40d-de6d-ec63e21eb496@eftlab.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi team,

Our customer was able to sneak in an Unicode data into a column of a JSON Type and now that record fails on select.

[cid:part1(dot)hzRCQplU(dot)TJZnhVJk(at)eftlab(dot)com(dot)au]

Would you be able to suggest any way out of this? E.g. finding infringing row, updating its data ... ?

Thanks & Cheers,
Jan

--
Jan Bilek - CTO at EFTlab Pty Ltd.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PALAYRET Jacques 2023-02-27 07:26:15 Interval in hours but not in days Leap second not taken into account
Previous Message Neethu P 2023-02-27 03:52:36 Re: Event Triggers unable to capture the DDL script executed