FOR XML could not serialize the data for node 'NAME' because it contains a character (0x001A) which is not allowed in XML.

Se utilizzando il metodo FOR XML per concatenare i record, ritorna questo messaggio di errore:

FOR XML could not serialize the data for node 'NAME' because it contains a character (0x001A) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.

si può fare una REPLACE:

replace(NAME NAME COLLATE Latin1_General_BIN2, char(26), '?')

esempio:

SELECT OpzIdList = ISNULL(
  STUFF((
   SELECT ', ' + REPLACE(ISNULL(o.OpzId, ''), CHAR(26), '?')
   FROM Table1 o
   WHERE o.Id = s.id
   ORDER BY o.OpzId
   FOR XML PATH(''), TYPE
  ).value('.', 'nvarchar(MAX)'), 1, 1, '')
 , '')
FROM Table1

Trovato qui.

NuGet info

paths:

C:\Users\\AppData\Roaming\NuGet contains NuGet.Config file

C:\Users\\AppData\Local\NuGet\Cache contains NuGet Cache







http://www.hanselman.com/blog/HowToAccessNuGetWhenNuGetorgIsDownOrYoureOnAPlane.aspx