|
![HTTP_DECODE function [HTTP]](gif/backward.gif)
Encodes special characters in strings for use with HTTP.
HTTP_ENCODE( string )
string Arbitrary string to be used in an HTTP request.
This function returns the string argument after making the following set of substitutions. In addition, all characters with hexadecimal codes less than 1F 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 0x1f and greater than 0x7f | %nn |
This function supports NCHAR inputs and/or outputs.
SQL/2003 Vendor extension.