https://community.qlik.com/t5/Talend-Studio/Problem-msssql-function-returning-XML-larger-then-4000/m-p/2331461#M100445 <P>Hi all,</P><P></P><P></P><P>I have a function in microsoft sqlserver where outcom is returned as XML</P><P>Already tried some variants like converting this to String (XML is missing part &gt;4000 chars) in the SQLserver function</P><P>XML returning from function cannot be loaded into a document type </P><P>Return into an object or byte array gives "Implicit conversion from data type xml to varbinary is not allowed. Use the CONVERT function to run this query."</P><P></P><P></P><P>Not sure wheter this error is caused by JDBC or SQLserver </P><P>Anyone already had same issue?</P><P></P><P></P><P>thanks,</P><P></P><P></P><P>Nico</P> Sat, 16 Nov 2024 00:26:16 GMT nico_vandevelde 2024-11-16T00:26:16Z https://community.qlik.com/t5/Talend-Studio/Problem-msssql-function-returning-XML-larger-then-4000/m-p/2331461#M100445 <P>Hi all,</P><P></P><P></P><P>I have a function in microsoft sqlserver where outcom is returned as XML</P><P>Already tried some variants like converting this to String (XML is missing part &gt;4000 chars) in the SQLserver function</P><P>XML returning from function cannot be loaded into a document type </P><P>Return into an object or byte array gives "Implicit conversion from data type xml to varbinary is not allowed. Use the CONVERT function to run this query."</P><P></P><P></P><P>Not sure wheter this error is caused by JDBC or SQLserver </P><P>Anyone already had same issue?</P><P></P><P></P><P>thanks,</P><P></P><P></P><P>Nico</P> Sat, 16 Nov 2024 00:26:16 GMT https://community.qlik.com/t5/Talend-Studio/Problem-msssql-function-returning-XML-larger-then-4000/m-p/2331461#M100445 nico_vandevelde 2024-11-16T00:26:16Z