OK, ehm, considering Heikki's post, why does MySQL take care of case-sensitive table names at all? I'm not that familiar with the whole thing about it, but aren't database names also case-insensitive? I know that column names are. So why isn't this option removed and table names are generally treated case-insensitive? (E.g. forcing lowercase_tablenames=1 anywhere.) This won't resolve the problems with older database servers though, as long as I have no chance to change the lowercase_tablenames setting (BTW, can I change this per connection?), but in future, this problem could be avoided.
-- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) On Wednesday, December 17, 2003 11:37 PM CET, Matt W wrote: > Hi, > > I saw the change as soon as it was posted last week or whenever and > didn't think anything of it. But the point Yves brings up seems very > important! > > Although, I'm not sure what to do then with "bug #1812." Too bad > MySQL's code can't make database/table names case-sensitive like on > *nix. e.g. *Force* the case used in queries match that of the > directory/file name... > > > Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]