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

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