<?xml version="1.0" encoding="UTF-8"?>

<root>
...
</root>

quote:

---

Originally posted by Kristen

Well, I don't suppose that the characters will display here, but the tag in question is:

<sys_html_Text><b>xx xxxxxxxxxxx xxxxxxxxxxx: +25#56130;#57184;0#56154;#57140;;/b><br>
xxxx ... xxxx</sys_html_Text>

---

quote:

---

Originally posted by Kristen

I was really surprised with it too. The thing I pasted it from had each "[Degree]C" as a square box. Goodness knows why/what it apparently concatenated the symbol PLUS the 'C' into a single Unicode character ...

---

DROP TABLE XMLCollationTest
GO

CREATE TABLE XMLCollationTest
(
  n int PRIMARY KEY,
  c1 varchar(20) COLLATE Latin1_General_BIN NOT NULL,
  c2 varchar(20) COLLATE Latin1_General_BIN NOT NULL
)

DECLARE @n int
SET @n = 32	-- Start with a space

-- fill varchar columns with English and CHAR versions of each character
SET NOCOUNT ON
BEGIN TRANSACTION
WHILE @n < 256 BEGIN
	INSERT INTO XMLCollationTest (n, c1, c2)
	SELECT	[n] = @n, 
		[c1] = 'Char-' + CONVERT(varchar(20), @n),
		[c2] = '[' + CHAR(@n) + ']'
	SET @n = @n + 1
END
COMMIT TRANSACTION
SET NOCOUNT OFF
GO

/**

-- DEBUG : Check what was stored
SELECT	*
FROM	XMLCollationTest
ORDER BY n

**/

SELECT 
	[Tag] = 10,
	[Parent] = NULL,
	[XMLCollationTest!10!n!element]		= n,
	[XMLCollationTest!10!c1!element]	= c1,
	[XMLCollationTest!10!c2!element]	= c2
FROM	dbo.XMLCollationTest
ORDER BY [XMLCollationTest!10!n!element],
	[Tag]
FOR XML EXPLICIT

-- Check for rogue characters before XML export
DECLARE	@strPattern	nvarchar(1000)
SELECT	@strPattern = '%[^-+_(),.:;!&*#@?%=<>/"'' 0-9A-Za-z' 
		+ CHAR(13) + CHAR(10) + CHAR(9) + CHAR(96)	-- Permitted
		-- Rogue characters found so far
		+ CHAR(145) + CHAR(146) + CHAR(147) + CHAR(148) + CHAR(150) + CHAR(151) + CHAR(153) + CHAR(163)	-- ...
		+ ']%'
-- Show a few sample values, not already found.
-- Convert CR LF and TAB to single character to make character position indication easier
SELECT 	TOP 100 MyPK, 
	[Offset] = PATINDEX(@strPattern, MyStringColumn),
	[ASCII] = ASCII(SUBSTRING(MyStringColumn, PATINDEX(@strPattern, MyStringColumn COLLATE Latin1_General_BIN), 1)),
	CHAR(13)+CHAR(10)+'          ' + REPLICATE('.', PATINDEX(@strPattern, MyStringColumn COLLATE Latin1_General_BIN)-1)+'v',
	CHAR(13)+CHAR(10)+'          ' + REPLACE(REPLACE(REPLACE(MyStringColumn, CHAR(13), '¬'), CHAR(10), '¬'), CHAR(9), '¬')
FROM	dbo.TEMP_ImportData
WHERE	   MyStringColumn LIKE @strPattern COLLATE Latin1_General_BIN

	RETURN	 REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE
			(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
			@strData
-- See http://www.ascii.cl/htmlcodes.htm
-- NOTE: Space added after each "&" to prevent forum displaying as character!
			, CHAR(145), '& #8216;')		-- ‘ (See note 1)
			, CHAR(146), '& #8217;')		-- ’ (See note 1)
			, CHAR(147), '& #8220;')		-- “ (See note 1)
			, CHAR(148), '& #8221;')		-- ” (See note 1)
			, CHAR(150), '& ndash;')		-- –
			, CHAR(151), '& mdash;')		-- —
			, CHAR(153), '& #8482;')		-- ™ (See note 1)
			, CHAR(163), '& pound;')		-- £
			, CHAR(174), '& reg;')		-- ®
			, CHAR(176), '& deg;')		-- °
			, CHAR(178), '& sup2;')		-- ²
			, CHAR(180), '& acute;')		-- ´
			, CHAR(183), '& middot;')	-- · Might be intended to be a bullet
			, CHAR(186), '& ordm;')		-- º
			, CHAR(188), '& frac14;')	-- ¼
			, CHAR(189), '& frac12;')	-- ½
			, CHAR(190), '& frac34;')	-- ¾
			, CHAR(191), '& iquest;')	-- ¿
			, CHAR(239), '& iuml;')		-- ï
-- Notes: (1) HTML 4.01, ISO 10646, ISO 8879, Latin extended A and B, Browser support: Internet Explorer > 4, Netscape > 4

quote:

---

[...]
			, CHAR(150), '–')		-- –
			, CHAR(151), '—')		-- —
[...]
			, CHAR(163), '£')		-- £
			, CHAR(174), '®')		-- ®
			, CHAR(176), '°')		-- °
			, CHAR(178), '²')		-- ²
			, CHAR(180), '´')		-- ´
[...]

---