HTTP_ENCODE function [Web service]

Encodes strings for use with HTTP. This is also known as URL encoding.

Syntax

HTTP_ENCODE( string )

Parameters

string – Arbitrary string to be encoded for HTTP transport.

Returns

LONG VARCHAR or LONG NVARCHAR

Remarks

This function returns the string argument after making the following set of substitutions. In addition, all characters with hexadecimal codes less than 20 or greater than 7E are replaced with %nn, where nn is the character code.

Character	Substitution
space	%20
"	%22
#	%23
%	%25
&	%26
,	%2C
;	%3B
<	%3C
>	%3E
[	%5B
\	%5C
]	%5D
`	%60
{	%7B
\|	%7C
}	%7D
character codes `nn` that are less than 0x20 and greater than 0x7f	%`nn`

This function supports NCHAR inputs and/or outputs.

Standards and compatibility

SQL/2008 – Vendor extension.

Examples

SELECT HTTP_ENCODE('/opt&id=123&text=''oid:c\x09d ef''')