Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions



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 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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.