Make mysql sensitive?

Question

I wrote

select * from mytable

In my ASP.net application on Windows, it works fine. On Linux, it complains that I used mytableinstead mytable. How do I configure MySQL on Windows to be case sensitive or make Linux case insensitive when working with table names?

Answer 1

See 8.2.2. Identifier case sensitivity in the mySQL manual.

Short version: use a system variable lower_case_table_namesto provide case insensitive Linux / Unix.

Answer 2

. . : http://www.parkroad.co.za/blog/2007/02/07/mysql-case-sensitivity-of-table-names-between-windows-and-linux-systems

: ... : lower_case_table_names my.ini, : C:\Program Files\MySQL\MySQL Server 4.1, , . , my.ini, , :

lower_case_table_names = 0

Dan