MySQL Forums
Forum List  »  MySQL Administrator

Re: Ignoring case in table names
Posted by: Ronan Cashell
Date: April 22, 2011 05:57PM

The case sensitivity is because each table is stored as a file name. On UNIX/Linux systems the operating system access to files is cases sensitive. On Windows it is case insensitive as files are accessed with no case sensitivity. Mac OS X which is a UNIX like OS also is case insensitive.

Also if you look at the following system parameter lower_case_table_names, this can be set to determine the sensitivity of accesses to the underlying tables.

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com

Options: ReplyQuote


Subject
Written By
Posted
April 18, 2011 10:50PM
Re: Ignoring case in table names
April 22, 2011 05:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.