mysql - 如何在Linux环境中禁用区分大小写

Question

这个问题已经有答案了:

How to change MySQL table names in Linux server to be case insensitive? (6 个回答)

已关闭 9 年前。

我正在 Ubuntu 机器上使用在 Windows 机器上创建的 MySQL 架构。但是当我的应用程序尝试访问数据库时，我得到了

Table 'schema.Booking' doesn't exist

如何禁用此功能以使存储过程不区分大小写？

Answer 1

Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows. If you transfer your statements to Unix, where lettercase is significant, they do not work if the lettercase is incorrect.

参见:http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html