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

Поиск
Список
Период
Сортировка
От Jan Bilek
Тема ERROR: unsupported Unicode escape sequence - in JSON-type column
Дата
Msg-id 43a45b6e-08f6-b40d-de6d-ec63e21eb496@eftlab.com.au
обсуждение исходный текст
Ответ на PCI:SSF - Safe SQL Query & operators filter  (Jan Bilek <jan.bilek@eftlab.com.au>)
Ответы Re: ERROR: unsupported Unicode escape sequence - in JSON-type column  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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.

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.
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Neethu P
Дата:
Сообщение: Re: Event Triggers unable to capture the DDL script executed
Следующее
От: PALAYRET Jacques
Дата:
Сообщение: Interval in hours but not in days Leap second not taken into account