MySQL Forums
Forum List  »  Newbie

Can make search for table name insensitive
Posted by: Steve Ricketts
Date: May 05, 2012 03:19PM

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?

Options: ReplyQuote

Written By
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.