当前位置：网站首页>Line feed in string value when sqlserver parses JSON

Line feed in string value when sqlserver parses JSON

2022-04-22 02:23:00 【CSDN Q & A】

The phenomenon and background of the problem

sqlserver analysis json when , If it appears in the string A newline ISJSON() Validation failed

declare @json nvarchar(4000)
-- If there is no newline character in the string, it can be verified as valid JSON
select @json=N'{
"id": "WakefieldFamily"
}'
select ISJSON(@json)--1==>true
-- If the string contains a newline character, it can be verified as invalid JSON, But actually I need to save these line breaks
select @json=N'{
"id": "WakefieldFamily
123
456
"
}'
select ISJSON(@json)--0==>false