CODEWITHSUNDEEP
mysqldatabaselanguage-agnostic
βӔḺṪẶⱫŌŔ
βӔḺṪẶⱫŌŔ

Reputation: 1296

Are Table names in a Query supposed to be Case-SensitIvE?

Are Table names in a Query supposed to be Case-SensitIvE in MySQL?

For example, if I do the following:

var query = "SELECT something FROM thAt WHERE this = '". $everything ."'";

If the actual table name is all lowercase, and I use a combination of upper and lowercase in my select query, SHOULD it match? Is table names in queries supposed to be case-(in)sensitive?

Upvotes: 2

Views: 1921

Answers (2)

Mark Cidade
Mark Cidade

Reputation: 100047

From < Is SQL syntax case sensitive? >:

Mysql has a configuration option to enable/disable it. Usually case-sensitive table and column names are the default on Linux MySql and case-insensitive used to be the default on Windows, but now the installer asked about this during setup. For MSSQL it is a function of the database's collation setting.

Here is the MySql page about name case-sensitivity: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Here is the article in MSDN about collations for MSSQL: http://msdn.microsoft.com/en-us/library/ms143503(SQL.90).aspx

Upvotes: 8

kqnr
kqnr

Reputation: 3596

As per the documentation here, case sensitivity of table names is filesystem-dependent. On Windows, they are case insensitive.

Upvotes: 3

Related Questions