MySQL on Linux: Queries Cannot Run Properly. Can’t Find Tables. Setup For Case Sensitivity Issues

Issue:

MySQL on Linux: Queries Cannot Run Properly. Can’t Find Tables. Setup For Case Sensitivity Issues

Solution:

By default MySQL for Linux is setup with case sensitivity on. Ephesoft and it’s underlying queries were designed with case insensitivity. If you are connecting to MySQL based on Linux, you must turn case sensitivity off for mysql BEFORE creating the Ephesoft databases.
On linux systems, to create tables properly so that case sensitivity is ignored, add the following line to /etc/mysql/my.ncf and restart MySQL service.

[mysql]
#
# * Basic Settings
#
# creates new tables in lowercase and passes new queries as lower case no matter if the query is written in UPPER or LOWER case
lower_case_table_names = 1

If you created the Ephesoft tables BEFORE turning case sensitivity off, you will need to rename existing tables that have any UPPER case characters to ones with lower case only.




Was this article helpful to you?

J.D. Abbey