Can anyone solve this Case-Sensitive problem on Linux OS?
I am using RedHat 9 Operating System. I have installed MySQL-5.0.45 & I am using MySQL-GUI-Tool 5.0 also.
Now I want to make all MySQL table names as non-case-sensitive.
For an Example:
if we will create a table name as "customerdetail", can we access the same table name as "CustomerDetail" or "CUSTOMERdetail" on queries. Can we access like this? ie., the query like
"select * from CUSTOMERdetail;" instead of "select * from customerdetail;".
Is it possible on Linux OS?
I had try with lower_case_table_names=2 on \etc\my.cnf. But it couldn't work. It couldn't support for both MySQL and its GUI Tool.
If any possible to set lower_case_table_names=2 on \etc\my.cnf file instead of lower_case_table_names=1.
Is it possible to change? Is it work insensitive mode perfectly,if we set as 2 on Linux OS?
Is it possible to set on MySQL-GUI-Tool 5.0 in linux OS?
I am waiting for your reply.