Help Center/ GaussDB/ MySQL Compatibility(Distributed)/ MYSQL-compatible Mode/ SQL/ DCL
Updated on 2025-06-30 GMT+08:00
View PDF
Share

DCL

Table 1 DCL syntax compatibility

Description

Syntax

Difference

Set names with COLLATE specified.

SET [ SESSION | LOCAL ] NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT};

GaussDB does not allow charset_name to be different from the database character set. For details, see "SQL Reference > SQL Syntax > S > SET" in Developer Guide.
Parent topic: SQL