Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

6.6 KiB

Raw Permalink Blame History

encode

This function is used to encode str in charset format.

Syntax

encode(string <str>, string <charset>)

Parameters

**Table 1** Parameters
Parameter	Mandatory	Type	Description
str	Yes	STRING	At least two strings must be specified. The value is of the STRING type. If the value is of the BIGINT, DECIMAL, DOUBLE, or DATETIME type, the value is implicitly converted to the STRING type for calculation.
charset	Yes	STRING	Encoding format. The options are UTF-8, UTF-16, UTF-16LE, UTF-16BE, ISO-8859-1, and US-ASCII.

Return Values

The return value is of the BINARY type.

If the value of str or charset is NULL, NULL is returned.

Example Code

Encodes string abc in UTF-8 format. An example command is as follows:
The value abc is returned.
```
select encode("abc", "UTF-8");
```
The value of any input parameter is NULL. An example command is as follows:
The return value is NULL.
```
select encode("abc", null);
```

Parent topic: String Functions

6.6 KiB Raw Permalink Blame History