SET CHARSET

Function

Sets the character encoding type of the client.

Precautions

This statement is equivalent to set client_encoding in openGauss.
Set this parameter based on the front-end service requirements. Ensure that the client code is the same as the server code to improve efficiency.
It is compatible with all encoding types of PostgreSQL.

Syntax

SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT}

Parameter Description

{CHARACTER SET | CHARSET}
```
 The two are equivalent.
```

{'charset_name' | DEFAULT}

 charset\_name supports the character encoding types that can be set by openGauss, such as utf8 and gbk. If DEFAULT is specified, the character set is reset to the default one.
 charset\_name supports the following formats:

 1. utf8
 2. 'utf8'
 3. "utf8"

Examples

openGauss=# show client_encoding;
-[ RECORD 1 ]---+----
client_encoding | GBK

openGauss=# set charset gbk;
SET
db_show=# show client_encoding;
-[ RECORD 1 ]---+----
client_encoding | GBK

openGauss=# set charset default;
SET
openGauss=# show client_encoding;
-[ RECORD 1 ]---+-----
client_encoding | UTF8

openGauss=# set character set 'gbk';
SET
openGauss=# show client_encoding;
-[ RECORD 1 ]---+----
client_encoding | GBK

openGauss=# set character set default;
SET
openGauss=# show client_encoding;
-[ RECORD 1 ]---+-----
client_encoding | UTF8