Escape json string

[ovehalseth-1]

I was starting on a function to replace characters that json needs to be escaped. But sybase is to clever and replaces \\n back into line break 😞

The function: ALTER FUNCTION "DBA"."JsonEnc"(IN str LONG VARCHAR ) RETURNS LONG VARCHAR DETERMINISTIC BEGIN return replace(str,char(10),'\\n') END

Test query: select 'aaa' || char(10) || 'bbb' as str, jsonenc(str) as jsonstr, replace(str,char(10),'\\n') as test

Result: str | jsonstr | test aaa aaa aaa\\nbbb bbb bbb

If the funtion replaces with say: |n it works as expected.

How do I get the function to not turn \\n back to line break.

Or is there a simpler way to escape a json string?

[ovehalseth-1]

Hmm, the Result in the question did not survive formatting...

[VolkerBarth]

I do not know for sure for Unicode, but for single-byte char sets, it should hold that CHAR(10) = '\\n', so that isn't really a replacement.

select ascii('\\n'), ascii(char(10)), ascii(char(13))

returns 10, 10, 13

And the FOR JSON clause will treat whitespace accordingly, without need for replacement AFAIK - see CHAR(10) and '\\n' are handled identically:

select 'aaa' || char(10) || 'bbb\\ncccc\\\\AfterTheBackspace' as strJson for json auto

returns [{"DUMMY":{"strJson":"aaa\\nbbb\\ncccc\\AfterTheBackspace"}}]

Note: The real return has two adjacent baskslashes before the word "After", the page format won't show the second...

[johnsmirnios]

'\\n' is a two-character string consisting of a backslash and an n. '\\n' is identical to char(10) so replace( x, char(10), '\\n' ) does nothing.

Perhaps the difference you see in the query might have to do with the client you are using to view the result? It could be displaying a character 10 as \\n. Try using \\n in the query and see if you get a result which is (visually) the same.

[ovehalseth-1]

Bah, return replace(str,char(10),'\\\\n')

Needs to escape the \\

Not sure why the replace in the query does not need to escape the \\