Re: Table Name Case Sensitivity

2004-02-23 Thread Peter Zaitsev
On Mon, 2004-02-23 at 08:56, Tim Hayes wrote: > 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 variab

Re: Table Name Case Sensitivity

2004-02-23 Thread Paul DuBois
At 16:56 + 2/23/04, Tim Hayes wrote: 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! Correct. You must set it using an option at server start

Re: Table Name Case Sensitivity

2004-02-23 Thread Heikki Tuuri
mes' 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: > > C

Re: Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
al 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? >

Re: Table Name Case Sensitivity

2004-02-23 Thread Alec . Cawley
"Tim Hayes" <[EMAIL PROTECTED]> wrote on 23/02/2004 16:15:36: > Can anyone offer advice? > > 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 >

Re: Table Name Case Sensitivity

2004-02-23 Thread Jochem van Dieten
Tim Hayes said: > Can anyone offer advice? > > 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

Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
Can anyone offer advice? 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

MySQL table name case sensitivity

2001-11-29 Thread Michael Collins
Since Mac OS X is Unix it should use the same rules as a Unix machine when it comes to MySQL and case sensitivity of table and database names. According to Dubois: "DB and tables in MySQL correspond to directories and files in the underlying file system on the server host. As a result, case se