Help Center/Data Lake Insight/Spark SQL Syntax Reference/Built-In Functions/Other Functions/url_encode
Updated on 2025-08-06 GMT+08:00
View PDF

url_encode

This function is used to encode a string into the application/x-www-form-urlencoded MIME format.

Syntax

url_encode(string <input>[, string <encoding>])

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

input

Yes

STRING

String to be entered

encoding

No

STRING

Encoding format. Standard encoding formats such as GBK and UTF-8 are supported. If this parameter is not specified, UTF-8 is used by default.

Return Values

The return value is of the STRING type.

If the value of input or encoding is NULL, NULL is returned.

Example Code

The value Example+for+url_encode+%3A%2F%2F+dsf%28fasfs%29 is returned.

select url_encode('Example for url_encode:// dsf(fasfs)', 'GBK');
Parent topic:Other Functions