Decodes HTTP encoded strings. This is also known as URL decoding.
SyntaxHTTP_DECODE( string )
Parametersstring Arbitrary string taken from a URL or URL encoded request body.
ReturnsLONG VARCHAR or LONG NVARCHAR
RemarksThis function returns the string argument after replacing all character sequences of the form %nn, where nn is a hexadecimal value, with the character with code nn. In addition, all plus signs (+) are replaced with spaces.
See also Standards and compatibilitySQL/2008 Vendor extension.
ExamplesSELECT HTTP_DECODE('http%3A%2F%2Fdcx.sybase.com') |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |