CharacterEscapes: Jackson’s hidden gem
At Kestra, the data orchestration platform I work for, we had an issue ([#10326] (https://github.com/kestra-io/kestra/issues/10326)) opened by a user reporting a problem with the PostgreSQL database and the Unicode character \u0000. A workflow task that returned this character in its output was failing. After investigation, PostgreSQL refuses to store a JSONB entry containing this character because it has no textual representation. This is because it is the null character in Unicode, which is not allowed in JSON, which represents null…