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
