InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 13:46:18 GMT20http://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxHi,It does not really help because I have no way to run it and see the problem. Meanwhile, my only guess is that something is going wrong with your REPLACE() function. You should be able to remove a character by using the REPLACE() function correctly.Wed, 18 Jun 2008 10:20:17 GMTjacob sebastianhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxThe SELECT :[code]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'[/code]With the FOR XML :[code]SELECT 1 as Tag, null as Parent, [NewsTitle] as [item!1!title!ELEMENT], [NewsSummary] as [item!1!description!CDATA], LEFT(DATENAME(dw, [NewsDate]),3) + ', ' + STUFF(CONVERT(nvarchar,[NewsDate],113),21,4,' GMT') as [item!1!pubDate!ELEMENT] FROM [sd_News] WHERE [IDChannel] = '11' FOR XML EXPLICIT[/code]After some tests, it seems that the problem occurs when the HTML data store in the column NewsSummary is very important.Regards.Wed, 18 Jun 2008 05:42:10 GMTLe Gloanechttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxcould you post some script that reproduces the problem?Wed, 18 Jun 2008 04:03:58 GMTjacob sebastianhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxThanks 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 magically appears at the end of a CDATA element like this [code]...0x00]]&gt;&lt;...[/code]I tried to force other column to CDATA but nothing appends.The column which cause this problem have as Data Type text, and store HTML code.have you already see that ?Wed, 18 Jun 2008 04:00:06 GMTLe Gloanechttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxIn our example, the REPLACE function is expected to remove the unwanted character (CHAR(0)). Try to run a SELECT query for the specific column and apply a REPLACE() operation and make sure those characters are removed from the query result.if that does not work, pls post some sample data. I will have a look at it and see If i can help you with this.regardsJacobTue, 17 Jun 2008 21:12:38 GMTjacob sebastianhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxHello,I have this error :[quote]hexadecimal value 0x00, is an invalid character[/quote]I sow your answer in Microsoft forum for a same problem:[quote]replace(description,CHAR(25),'')[/quote]I used the same function : REPLACE([NewsSummary],CHAR(0),'')but that do not work.Do you have an idea ?RegardsTue, 17 Jun 2008 09:25:25 GMTLe Gloanechttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxThanks 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 encodingI must use UTF-16. For information I use SQL server 2005.RegardsMon, 16 Jun 2008 09:38:15 GMTLe Gloanechttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxYou will have to do a string operation to do this. Look at the example given in the previous session: http://www.sqlservercentral.com/articles/XML/62661/Mon, 16 Jun 2008 05:09:11 GMTjacob sebastianhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxWith 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 line that i want to insert is [quote]?xml version="1.0" encoding="ISO-8859-1"?[/quote]Mon, 16 Jun 2008 04:43:11 GMTLe Gloanechttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxI think I did not understand the questions fully. could you elaborate?Mon, 16 Jun 2008 04:07:32 GMTjacob sebastianhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxThanks 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 compliant2) how to insert at the beginning of the XML result file this line RegardsMon, 16 Jun 2008 04:01:16 GMTLe Gloanechttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxVery useful ! Thanks a lotFri, 06 Jun 2008 00:52:02 GMTDamien Jolyhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxExcellent article..... Thanks.Wed, 04 Jun 2008 05:40:31 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic511146-356-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/XML/63043/">XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000)</A>[/B]Wed, 04 Jun 2008 00:23:43 GMTjacob sebastian