James Kelty; [EMAIL PROTECTED]
Subject: RE: Mysql Table Case
Answer is No.
Case-sensitivity of table names depends on operating system you are
running mysql on.MySQL stores table definitions in TABLENAME.* files. So
it will always be case-sensitive on *nix and case-insensitive on
windows.
N
At 9:59 -0700 8/15/02, James Kelty wrote:
>Hello,
>
>Is there a compile option or startup option to make mysql ignore table name
>case? So that the tables security and Security would be seen as the same
>table?
--set-variable=lower_case_table_names=1
But you should rename your tables to lowercas
:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: Mysql Table Case
Hello,
Is there a compile option or startup option to make mysql ignore table
name
case? So that the tables security and Security would be seen as the same
table?
-James
James Kelty
Director
Hello,
Is there a compile option or startup option to make mysql ignore table name
case? So that the tables security and Security would be seen as the same
table?
-James
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488.0801