Help Center/ GaussDB/ MySQL Compatibility(Distributed)/ MySQL Compatibility in M-compatible Mode/ SQL/ DCL
Updated on 2024-12-06 GMT+08:00
View PDF
Share

DCL

Table 1 DCL syntax compatibility

No.

Description

Syntax

Difference

1

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 > SQL Statements > S > SET" in the M-compatible Developer Guide.
Parent topic: SQL