HTML_ENCODE function [Miscellaneous]

Encodes special characters within strings to be inserted into HTML documents.

Syntax

HTML_ENCODE( string )

Parameters

string – Arbitrary string to be used in an HTML document.

Returns

LONG VARCHAR or LONG NVARCHAR.

Note: The result data type is a LONG VARCHAR. If you use HTML_ENCODE 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.

Remarks

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

Characters	Substitution
"	"
'	'
&	&
<	<
>	>
codes `nn` less than 0x20	&#x`nn`;

This function supports NCHAR inputs and/or outputs.

Standards and compatibility

SQL/2008 – Vendor extension.

Examples

The following example returns the string '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> '.

SELECT HTML_ENCODE('<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">')