I have this problem when performing a Informix to mariadb conversion. There are queries of this type that are equivalent in Informix:

select col1, col2, col3 from table1;
select Col1, Col2, Col3 from TABle1;

But in case of MariaDB this doesn’t work as it is case sensitive.

We have an option for table name via my.cnf file:

[mysqld]
lower_case_table_names=1

But for the column we don’t have a solution.

That means the previous two queries are not equivalent in MariaDB with the current settings we have.

Is there a configuration option, or any other option, that can help us make the columns in a query behave in a case-insensitive manner?

Thank you!