Skip to content

[Bug]: Result of NVARCHAR(MAX) column cut off #19668

Open
@kackburt

Description

@kackburt

Description

Expected that copying the query result would copy whole content a column.
Query result including column NVARCHAR(MAX) was cut off after a certain length of the content, even though the data is correctly stored in the column/datatype.

Steps to Reproduce

f.e. add a very long > 50.000 words lorem ipsum text or a long XML data set

CREATE TABLE t1 (
cutoff NVARCHAR(MAX)
);

INSERT INTO t1 (cutoff) VALUES ('{very-long-content-here}');

SELECT cutoff FROM t1

Affected Area

  • Connection dialog
  • Query results panel
  • Query editor
  • Object Explorer
  • Table Designer
  • Schema Compare
  • Schema Designer
  • Local container
  • GitHub Copilot integration
  • Query Plan Visualizer
  • Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

  • OS: macOS Sequoia 15.5
  • VSCode version: 1.100.3
  • MSSQL extension version: 1.33.0

Confirmation

  • I have searched existing issues and couldn't find a match
  • I want to work on this issue

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions