RE: Mysql Table Case

2002-08-15 Thread James Kelty
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

Re: Mysql Table Case

2002-08-15 Thread Paul DuBois
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

RE: Mysql Table Case

2002-08-15 Thread Nilesh Shah
:[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

Mysql Table Case

2002-08-15 Thread James Kelty
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