But this issue can be handled by MySQL. Take a look at the
lower_case_table_names system variable. With lower_case_table_names=1 on
the Linux/Unix server, table names will be stored as lower case. See the
manual <http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html> for
the details, and be sure to read the last sentence.
Michael
Jack Coxen wrote:
> This isn't caused by MySQL. It's an OS issue. Linux and Unix are case
> sensitive operating systems so any program you run, unless it is
> specifically written to be NON-case sensitive, is case sensitive as well.
>
> Jack
>
> -----Original Message-----
> From: Andre MATOS [mailto:amatos@stripped]
> Sent: Wednesday, May 12, 2004 10:53 AM
> To: mysql@stripped
> Subject: Case Sensitive
>
>
> Hi List,
>
> I have three MySQL servers. One is running on Windows XP, another on MacOS
> X, and finally one on Linux. All servers have the same version: 4.0.18.
>
> Every time when I create tables on the servers Windows XP and MacOS, MySQl
> creates the database without creating problems with the tables names (is
> not case sensitive). However, in the Linux I have problems (it follows
> exactly the name uppercase and lowercase is case sensitive).
>
> So, for example:
> On Windows/Mac: TestABC is created as testabc
> On Linux: TestABC is created as TestABC
>
> 1) How can I disable this in the MySQL server running on Linux?
>
> 2) What is better? Disable or enable the others two?
>
> By the way, I have the same problem with the usernames and passwords. How
> can I enable/disable MySQL case sensitive for data?
>
> Thanks.
>
> Andre
>
