On 3/5/07, abhishek jain <[EMAIL PROTECTED]> wrote:
On 3/1/07, abhishek jain <[EMAIL PROTECTED]> wrote: > > > On 2/28/07, Ow Mun Heng <[EMAIL PROTECTED] > 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 > > So friends , If anyone know abt the sol. pl. let me know Thanks, Abhishek jain