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?

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  December 10, 2010 at 2:44 am

  #1260934

  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);

• 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]