String or Binary Data Would Be Truncated: NVARCHAR(MAX), SQL Server 2008

Question

I've got a column called description of type NVARCHAR(MAX) - biggest you can have. I need to return this field with quotes around it, so I'm trying to

SELECT QUOTENAME(description, '"')

This doesn't work - I get a "string or binary data would be truncated error."

My googling tells me that this problem can be solved by using SET ANSI_WARNINGS OFF, but if I do that, I still get the same error anyway.

Normally I would just pull the values into a temp table and use a field that is two characters bigger than the field I'm pulling in, thus ensuring that the QUOTENAME function won't cause any problems. How do I make a column two characters bigger than MAX, though?

Kolappan N · Accepted Answer · 2017-07-20 21:58:05Z

5

QUOTENAME is a function intended for working with strings containing SQL Server identifier names and thus only works for strings less than or equal to the length of sysname (128 characters).

Why doesn't SELECT '"' + description +'"' work for you?

edited Jul 20, 2017 at 21:58

Kolappan N

4,0413 gold badges40 silver badges45 bronze badges

answered Apr 27, 2011 at 15:35

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

String or Binary Data Would Be Truncated: NVARCHAR(MAX), SQL Server 2008

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related