Page 1 of 1

MyDACDemo broken due to inconsistent tablename case

Posted: Fri 18 Jan 2008 11:12
by gwideman
Folks:
Most of the demos in MyDACDemo result in table-not-found errors, because the names used in the demo queries are different from the names used in the Create script -- they use different combinations of upper and lower case. Eg: EMP vs Emp.

This is OK on Windows, but not on linux, because the MySQL tables are stored in files (named according to tablename), and on linux upper/lower case of the filenames is significant.

Is there anything simple that can be done about this? Or must the user try to find all the places that a tablename appears, and fix the case?

Graham

Posted: Mon 21 Jan 2008 13:24
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.
As a temporary solution you can set the lower_case_table_names variable to 1 for your MySQL server.