Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Decodes special character entities that appear in HTML literal strings.
HTML_DECODE( 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.
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 http://www.w3.org/TR/html4/ and http://www.w3.org/TR/html4/sgml/entities.html#h-24.2.
The following statement returns the string <p>The piano was made for 'Steinway & Sons'.</p>:
<p>The piano was made for 'Steinway & Sons'.</p>
SELECT HTML_DECODE('<p>The piano was made ' ||
'by ‘Steinway & Sons’.</p>')
The following statement returns the string <p>It cost €85.000,000. </p>:
<p>It cost €85.000,000. </p>
SELECT HTML_DECODE('<p>It cost €85.000,000.</p>')