From: Martijn Tonies
Date: February 28 2007 9:47am
Subject: Re: Does casing of Table names matter on Linux
List-Archive: http://lists.mysql.com/mysql/205271
Message-Id: <008701c75b1d$665ba610$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> 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, this is a problem on Linux if you're using MyISAM etc, anything
that gets mapped to a file system filename.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com