Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions


HTML_DECODE function [Miscellaneous]

Decodes special character entities that appear in HTML literal strings.

HTML_DECODE( string )
  • string   Arbitrary literal string used in an HTML document.


This function returns the string argument after making the following set of substitutions:

Characters Substitution
" "
' '
& &
&lt; <
&gt; >
&#xhexadecimal-number; Unicode codepoint, specified as a hexadecimal number. For example, &#x27; returns a single apostrophe.
&#decimal-number; Unicode codepoint, specified as a decimal number. For example, &#8482; 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]

See also
Standards and compatibility
  • SQL/2003   Vendor extension.