MyDACDemo broken due to inconsistent tablename case
Posted: Fri 18 Jan 2008 11:12
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
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