Postgres Pro
Downloads
Home   >   mailing lists

ERROR: unsupported Unicode escape sequence - in JSON-type column - Mailing list pgsql-general

From Jan Bilek
Subject ERROR: unsupported Unicode escape sequence - in JSON-type column
Date
Msg-id 43a45b6e-08f6-b40d-de6d-ec63e21eb496@eftlab.com.au
Whole thread Raw
In response to PCI:SSF - Safe SQL Query & operators filter  (Jan Bilek <jan.bilek@eftlab.com.au>)
Responses Re: ERROR: unsupported Unicode escape sequence - in JSON-type column  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
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.

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.
Attachment

pgsql-general by date:

Previous
From: Neethu P
Date:
Subject: Re: Event Triggers unable to capture the DDL script executed
Next
From: PALAYRET Jacques
Date:
Subject: Interval in hours but not in days Leap second not taken into account