Check MySQL case-insensitive query or table name

I tried to install Umbrao CMS, it supports MySQL database but it need MySQL to support case-insensitive query and table name.

 

Following is way to check whether case-insensitive query is supported:

show variables where variable_name=’lower_case_table_names’;

or check lower_case_table_names option in my.ini (MySQL configuration file)

 

If this option’s value is set to 1, then case-insensitive query and table name is supported.