MySQL Forums
Forum List  »  Newbie

Re: mysql and xampp
Posted by: Rick James
Date: March 30, 2014 11:00PM

Are you migrating between different Operating Systems?

Windows insists on ignoring case.
Linux insists on matching case.

The best defense is to always use the same case in the SELECT (etc) as in the CREATE TABLE. Then, Linux will match them up; Windows will fold to lower both in the CREATE and the SELECT, so they will match.

Changing the 'lower%' settings may not work on all operating systems.

Options: ReplyQuote


Subject
Written By
Posted
March 29, 2014 07:53PM
March 30, 2014 04:07AM
March 30, 2014 11:30AM
March 30, 2014 05:42PM
March 30, 2014 07:22PM
March 31, 2014 01:26AM
Re: mysql and xampp
March 30, 2014 11:00PM
March 31, 2014 11:54AM
March 31, 2014 05:49PM


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.