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
