How to save emoji?

Question

PostgreSQL

I write json , where one of its fields contains emoji, in the base field with type json , gives such an error

DETAIL: Escape sequence "�" is invalid.

How can I write it down there? Looks like it's only UTF-8.
Are there any workarounds?

Answer 1

melkij=> select jsonb '"\ud83d\ude00"';
 jsonb 
-------
 ""
(1 строка)

melkij=> select json_build_object('emoji','');
 json_build_object 
-------------------
 {"emoji" : ""}

no problem. Check what exactly you are sending. Maybe the base is right and your escape sequence is invalid?