Decodes special character entities that appear in HTML literal strings.
HTML_DECODE( string )
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.
SAP Sybase IQ 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.
SELECT HTML_DECODE('<p>The piano was made ' || 'by ‘Steinway & Sons’.</p>')
SELECT HTML_DECODE('<p>It cost €85.000,00.</p>')