OK There is still the possibility of an in-compatability between the 2 platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not recognized / updateable using the set command! I get - Unknown system variable 'lower_case_table_names' Tim Hayes ----- Original Message ----- From: "Peter Zaitsev" <[EMAIL PROTECTED]> To: "Tim Hayes" <[EMAIL PROTECTED]> Sent: Monday, February 23, 2004 4:19 PM Subject: Re: Table Name Case Sensitivity > On Mon, 2004-02-23 at 08:15, Tim Hayes wrote: > > Can anyone offer advice? > > Run with lower_case_table_names=1 > > > > > > > > I have come across a MySQL database on Linux with duplicate table names - "Accounts" and "accounts". This seems fine on Linux, but does not transfer to the Windows environment - it is rejected because of the duplicate name. However I do see that Column Names have to be unique in both environments. > > > > Q. Is there some sort of practical advantage for having case sensitive table names in Linux, or is this a design "shortcoming"? Postgress rejects duplicate table names. > > > > Thanks > > Tim Hayes > -- > Peter Zaitsev, Senior Support Engineer > MySQL AB, www.mysql.com > > Meet the MySQL Team at User Conference 2004! (April 14-16, Orlando,FL) > http://www.mysql.com/uc2004/ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]