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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]