Decodes special character entities that appear in HTML literal strings.
HTML_DECODE( string )
string Arbitrary literal string used in an HTML document.
LONG VARCHAR
LONG NVARCHAR
This function returns the string argument after making the following set of substitutions:
| 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.
SQL Anywhere supports all character entity references specified in the HTML 4.01 Specification. See ![[external link]](gif/external.gif)
http://www.w3.org/TR/html4/.
SQL/2003 Vendor extension.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |