convert(varchar(max),xmltypevariable) works only for 8000 chars

Question

Post reply

convert(varchar(max),xmltypevariable) works only for 8000 chars

kuppurajm

SSCommitted

Points: 1593
More actions
December 9, 2010 at 9:47 pm

#232008

Hi,
print(convert(varchar(max),xmltypevariable)) works only for 8000 chars
Is there any oher way to do this?
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 1

The convert is working, it is just the display using "print" that is truncating it.

IF you print LEN(CONVERT(VARCHAR(MAX),xmltypevariable)) you will see the conversion has worked.

What are you hoping to do by PRINTing it?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

kuppurajm SSCommitted Points: 1593 More actions · Answer 2

Thank you much.

Now I understood.My requirement is only convert the variable not to print that.

So as u said conversion has worked without any problem.