HTML_DECODE function [Miscellaneous]

HTML_DECODE( string )

string Arbitrary literal string used in an HTML document.

LONG VARCHAR or LONG NVARCHAR

This function returns the string argument after making the appropriate substitutions. The following table contains a sampling of the acceptable character entities.

Characters	Substitution
"	"
'	'
&	&
<	<
>	>
&#xhexadecimal-number;	Unicode codepoint, specified as a hexadecimal number. For example, ' returns a single apostrophe.
&#decimal-number;	Unicode codepoint, specified as a decimal number. For example, ™ returns the trademark symbol.

When a Unicode codepoint is specified, if the value can be converted to a character in the database character set, it is converted to a character. Otherwise, it is returned uninterpreted.

SQL Anywhere supports all character entity references specified in the HTML 4.01 Specification. See [external link] http://www.w3.org/TR/html4/ and http://www.w3.org/TR/html4/sgml/entities.html#h-24.2.

SQL/2008 Vendor extension.

SELECT HTML_DECODE('&lt;p&gt;The piano was made ' ||
  'by &lsquo;Steinway &amp; Sons&rsquo;.&lt;/p&gt;')

SELECT HTML_DECODE('&lt;p&gt;It cost &euro;85.000,00.&lt;/p&gt;')

HTML_DECODE function [Miscellaneous]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Examples