List:General Discussion« Previous MessageNext Message »
From:abhishek jain Date:March 1 2007 5:53am
Subject:Re: Does casing of Table names matter on Linux
View as plain text  
On 2/28/07, Ow Mun Heng <Ow.Mun.Heng@stripped> wrote:
>
> On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote:
> > Hi Friends,
> > I have been developing one application over Windows and now i want to
> > move/port that into linux, i want to know will the casing of the table
> name
> > matter on linux ie if i have table name as tab1 and i execute query like
> > select * from TAb1 ,will it make an effect.
> > I have found that this is not a problem on windows but it is on linux, i
> > want a sol. for that a i can not change all the table names as in some
> > places it is in small case and in other places it is in capital case.
>
>
> Yes.. There is a difference. Casing Matters in *nix.
>
> However there is an option for turning if off.
>
> # http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html
> lower_case_table_names          = 1
>
>
> Hi Friends,
Thanks for the mails.
Now i have made a mistake.In mine code i have somwhere capital case and in
other place the small case for the table names.
I cannot change the case in mine code and cannot resist the change to the
Linux .
What is the remedy now i mean can something be done now to make linux be
case insensitive,
Pl. help me,
Thanks,
Abhishek jain

Thread
Does casing of Table names matter on Linuxabhishek jain28 Feb
  • Re: Does casing of Table names matter on LinuxOw Mun Heng28 Feb
    • Re: Does casing of Table names matter on Linuxabhishek jain1 Mar
  • Re: Does casing of Table names matter on LinuxMartijn Tonies28 Feb
  • Re: Does casing of Table names matter on LinuxMario Guenterberg28 Feb
Re: Does casing of Table names matter on Linuxabhishek jain5 Mar
  • Re: Does casing of Table names matter on LinuxGerald L. Clark5 Mar
  • Specific mysql Trigger questionWinn Johnston5 Mar