Whether table names and db names are case sensitive in mysql binlog file

142 Views Asked by At

I create a table as follow:

create table INTERFACE_INFO_PK_SIMPLE
(
    API_ID      VARCHAR(128) not null primary key,
    API_METHOD  VARCHAR(24),
    API_PATH    VARCHAR(1024),
    API_STATUS  VARCHAR(8),
    API_COMMENT VARCHAR(510),
    API_TYPE    VARCHAR(48)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;

In my mac os the 'lower_case_table_names' is 2 and I find the table name is lowercase in binlog file.

Does the config 'lower_case_table_names' have relationship with whther table name is case sensitive in binlog file?

If use a linux os pc and set 'lower_case_table_names=0', will the table name be upper case like 'INTERFACE_INFO_PK_SIMPLE' in binlog file in my case?

0

There are 0 best solutions below