I am installing a mysql database (which is on a Linux server at the moment) on a Windows server, and it is converting all of the case sensitive tables to all lower case. The queries are case sensitive, so I need the tables to maintain their correct case table names.
Is there a way to configure the database to not alter the case sensitivity?
I believe there is after reading [
dev.mysql.com] but I am not all that experienced in some of these matters.
Can anyone advise me how I change this system variable (in simple straightforward terms, please)
Thanks,
(Using MySQL 5.0)