MySQL Case Sensitive On Linux

PHP Programming 5 July 2007 1 Comment



A good rule to remember. MySQL are case sensitive only table and database identifiers and only on platforms with case-sensitive filenames (Linux/Unix). So, If you’re developing a system. Do remember. MySQL are case sensitive. An example:

Bad Practice:
select * from Project

Good Practice:
SELECT * FROM project

Ref: Identifier Case Sensitive



  • http://www.udjuni.com Simon

    That is such a pain though to switch between the cases. It is good if you have a good code editor. Had a similar situation with file names on linux too, apparently BIG and big are not the same, so I had to convert all my file names to lower case.