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
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
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
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?
>
"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
>
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
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
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