(SQL Server) Decode HTML Entities found in XML
Demonstrates how to decode HTML entities found in XML.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @sTmp0 nvarchar(4000)
-- Load an XML file containing the following:
-- <?xml version="1.0" encoding="UTF-8"?>
-- <output>Französische</output>
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Xml', @xml OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
EXEC sp_OAMethod @xml, 'LoadXmlFile', @success OUT, 'qa_data/xml/hasHtmlEntity.xml'
-- Get non-decoded content, then get decoded content.
-- Result is Französische
EXEC sp_OAGetProperty @xml, 'Content', @sTmp0 OUT
PRINT @sTmp0
-- Result is Französische
DECLARE @strDecoded nvarchar(4000)
EXEC sp_OAGetProperty @xml, 'Content', @sTmp0 OUT
EXEC sp_OAMethod @xml, 'DecodeEntities', @strDecoded OUT, @sTmp0
PRINT @strDecoded
EXEC @hr = sp_OADestroy @xml
END
GO
|