Skip navigation links

MySQL Forums :: Newbie :: Can make search for table name insensitive


Advanced Search

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


Subject Written By Posted
Can make search for table name insensitive Steve Ricketts 05/05/2012 03:19PM
Re: Can make search for table name insensitive Rick James 05/07/2012 07:38AM


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.