HTML_DECODE Function [HTTP]

Decodes special character entities that appear in HTML literal strings.

Syntax

HTML_DECODE ( string )

Note:

CIS functional compensation performance considerations apply.

The HTML_DECODE function is a SQL Anywhere function. See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Reference > Using SQL > SQL functions > SQL functions (E-O) > HTML_DECODE function [HTTP].

Returns

LONG VARCHAR

Note:

The result data type is a LONG VARCHAR. If you use HTML_DECODE in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set HTML_DECODE to the correct data type and size.