OK, so I'm on a slightly older version for this experiment (3.23.36).. I tried restarting mysqld with the line
set=lower_case_table_names=1 in my my.cnf (on RedHat 7.1), and have a table called "ipaddr" in my database (the files are ipaddr.frm, ipaddr.MYD and ipaddr.MYI). (I have verified with "show variables" that this setting has been accepted). However, the following query still fails: select * from IpAddr; (says ERROR 1146: Table 'test.IpAddr' doesn't exist). Am I misunderstanding what this option does? I'm trying to port some code from Oracle that's very careless about the case of table names, and I need it to work in MySQL on Linux.. Thanks in advance, -- Shankar. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
