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.

Syntax

HTML_DECODE( string )

Parameters

string    Arbitrary literal string used in an HTML document.

Remarks

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

CharactersSubstitution
""
''
&&
&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] http://www.w3.org/TR/html4/.

See also
Standards and compatibility