URL_ENCODE

This function escapes the given input value by encoding it so that it can be safely included in URL query parameter names and values:

• Alphanumeric characters are not encoded.
• The characters ., -, * and _ are not encoded.
• The ASCII space character is encoded as +.
• All other characters are converted to UTF-8 and the bytes are encoded as the string %XX where XX is the uppercase hexadecimal value of the UTF-8 byte.

Syntax

URL_ENCODE(VALUE)

Arguments

VALUE

Type: string

The value to encode.

Returns

Type: string

The encoded VALUE.

---

Examples

Example

SQL

//url_example1
        URL_ENCODE('word+word  word')

//url_example2
        URL_ENCODE('&$#_line_!123')

Query result