Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 09-12-2007, 05:22 AM   #1
LQ Newbie
Registered: Sep 2007
Posts: 1

Rep: Reputation: 0
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.

Old 09-12-2007, 06:17 AM   #2
LQ Addict
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,894

Rep: Reputation: 351Reputation: 351Reputation: 351Reputation: 351
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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linux case sensitive does not treat! mehjabin_25 Linux - Newbie 4 01-04-2006 07:53 AM
is apache case-sensitive? browny_amiga Linux - Software 2 06-21-2004 01:57 PM
Why is linux case sensitive? Jestrik Linux - General 9 12-16-2003 07:05 AM
case sensitive groupadd? sysmaster Linux - General 0 07-28-2003 04:53 AM
case-sensitive issue david_wliu Linux - General 4 03-06-2003 10:46 PM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 07:03 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration