If you are developing your app on Microsoft Windows and you are planning to run it on Linux, you will have to seriously pay attention to the letter casing of your inputs. This includes commands, filenames, but also database and table names since table names in MySQL are file system entries, so they are case-sensitive if their operating system is so.

Example of filenames on Linux

Remember: Filenames are not case-sensitive in Windows, but they are in most varieties of Unix or Linux.

Example:

"SELECT * FROM Users" is different from "SELECT * FROM users".

If you are wondering why these two systems act differently, the answer is because they were developed differently.

• UNIX/Linux systems are case-sensitive, because capital and small letters are different characters in the encoding standards.
• Windows, on the other hand, is case-insensitive, because historically, it attempted to retain a backward compatibility with the older MS-DOS convention that used uppercase to represent filenames.