Hi,

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.

Regards,
Yuvaraj.D

Here is an article that might help. http://searchenterpriselinux.techtar...073297,00.html

And remember, after making changes to /etc/my.cnf, you must restart the mysql service for the changes to take effect.