Skip to content

SQL Server: Support large JSON string properties (>4000) #29477

@roji

Description

@roji

Member access with JSON documents is currently translated using JSON_VALUE. That function returns nvarchar(4000), and doesn't support larger values (it either returns null or errors, depending on lax vs. strict mode). The documented workaround on that doc page is to use OPENJSON, so we may want to think about switching to that.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions