Can make search for table name insensitive
I've just installed mySQL on openSUSE 12.1 and am trying to search on a table (etutor) but I want it to be case insensitive. I've set lower_case_table_names=1 and all of my files (.frm) are in lower case. However, if I were to do a select like:
select * from eTutor
I get an error that says eTutor doesn't exist. What have I understood incorrectly about how to set case insensitivity?
Subject
Written By
Posted
Can make search for table name insensitive
May 05, 2012 03:19PM
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.