Kurinchi Blogger Scribbles …


Archive for March 6th, 2009

Mar 06
2009

MySQL Case Sensitivity

Last updated: March 10th, 2009

Is MySQL Case-Sensitive?
The SQL syntax is NOT case-sensitive in MySQL.

If the application written in PHP/Perl or other languages were to be used in Microsoft & Linux environment, then it would really be an issue for the database administrators and for the programmers.

That is the reason why you might have noticed books or sites saying that it is always recommended to treat MySQL syntax as being case-sensitive.

It was interesting to learn that the database name remains case sensitive.


Valid HTML 4.01 Strict  Valid HTML 4.01 Strict