U0400039: The default value definition for STRING data types in GaussDB (M-compatible mode) does not support "\0"(0x00)

If the value of GUC parameter m_format_behavior_compat_options contains enable_escape_string, GaussDB does not support "\0"(0x00) as the default value of a column. As a result, the table that uses "\0" as the default value of a column fails to be created. If the value of m_format_behavior_compat_options does not contain enable_escape_string, GaussDB does not report an error. Different from MySQL, GaussDB regards "\0" as a common string consisting of two characters. For example, if you execute the following statement, this error will be reported.

CREATE TABLE test_default_val_0x00(    
id          INT,
c_char      CHAR(3)       DEFAULT '\0\0\0',
c_varchar   VARCHAR(10)   DEFAULT '\0\0\0',
c_binary    BINARY(3)     DEFAULT '\0\0\0',
c_varbinary VARBINARY(10) DEFAULT '\0\0\0' 
);