Files and folders in
Unix platforms in general are case sensitive making
MariaDB table names in these platforms to also be case sensitive.
Windows however does not enforce case sensitivity for its folders and files causing
MariaDB table names in
Windows to not be case-sensitive.
This means that a lowercase table named
tablename is just the same as uppercase
TableName and using any of these will not make any difference in your query. This is due to the fact that
MariaDB stores and query database tables based on the filesystem's filename and folder.
You can use case-insensitive table name for
Linux or other
Unix systems by enabling it in the configuration file.
Steps to enable case-insensitive table name in MySQL and MariaDB:
MariaDBconfiguration file using your favourite editor.
Add the line if it doesn't already exist.
Comment anonymously. Login not required.