LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices

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

Rep: Reputation: 0
Can anyone solve this Case-Sensitive problem on Linux OS?


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
 
Old 09-12-2007, 06:17 AM   #2
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian Squeeze
Posts: 5,787

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


Reply


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


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

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