Re: References to tables being case sensitive

[Jonathan Stephens]

Windows, unlike nearly every other operating system, ignores case. In order to maximise portability across operating systems and programming languages, the best practise is to observe case-sensitivity for all identifiers in your MySQL applications, but not to depend on it to differentiate between them.

In other words, if you name a table ¨Report¨, always refer to it as ¨Report¨ and not as ¨report¨ or ¨REPORT¨. Don´t try to name any other table ¨report¨ or ¨REPORT¨.

More info: http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle