HTTP_ENCODE( string )

LONG VARCHAR or LONG NVARCHAR

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.

This function supports NCHAR inputs and/or outputs.

• HTTP_DECODE function [Web service]
• Web services functions
• Web services system procedures

The following statement returns the string /opt%26id=123%26text='oid:c%09d%20ef':

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