The SELECT :

SELECT

1 as Tag,

null as Parent,

[NewsTitle],

[NewsSummary],

LEFT(DATENAME(dw, [NewsDate]),3) + ', ' + STUFF(CONVERT(nvarchar,[NewsDate],113),21,4,' GMT')

FROM [sd_News] WHERE [IDChannel] = '11'

With the FOR XML :

SELECT

1 as Tag,

null as Parent,

[NewsTitle] as [item!1!title!ELEMENT],

[NewsSummary]...

Thanks for your suggestion, the result of this test is incredible :

With a SELECT the 0x00 character is not present and after use a FOR XML EXPLICIT the 0x00 character...

Hello,

I have this error :

I sow your answer in Microsoft forum for a same problem:

I used the same function : REPLACE([NewsSummary],CHAR(0),'')

but that do not...

Thanks for your answer.

With the encoding information, the line feed problem was disappeared.

With UTF-8 I was an error : XML parsing: line 1, character 39, unable to switch the encoding

I...

With the line feed each 2034 character the XML result file can not be interpret well by other application because the line feed cut XML tag or data in element.

The...

Thanks for this great and useful article.

I have 2 questions :

1) In my result i have each 2034 character a feed line that make my xml file not XML compliant

2)...