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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

HOURS function [Date and time] Next Page

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:

&#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