Overview of GaussDB Compatibility

In GaussDB, you can create a database whose compatibility mode is set to A, B, C, PG, or M, which represent the database is in Oracle-compatible, MySQL B-compatible, TD-compatible, POSTGRES-compatible, or MySQL M-compatible mode, respectively. The compatibility mode may affect SQL syntax, data types, system functions, and stored procedures. Some compatibility APIs are supported only in the corresponding compatibility mode.

The M-compatible mode is highly compatible with MySQL databases in terms of syntax, data types, metadata, and protocols. The B-compatible mode will not evolve because it is not compatible with the MySQL architecture.

For details about Oracle-compatible mode, M-compatible mode, and B-compatible mode, see Oracle Compatibility Description, M-compatible Mode, and B-compatible Mode. You can select a proper compatibility mode based on actual requirements.