Database Table Name Case on Linux Systems

Jan 8, 2012 at 7:47 AM

Has anyone had any experience with running the mysql scripts and using the database on a linux system. I noticed that the table names were lowercase in the create statements while the names were capitalized (mixed case) in the stored procedures. This could potentially cause problems if the file system supports case sensitive naming conventions, such as linux. I know that attempts to utilize a flag could help, but it could also cause problems with corruption in mysam indexes. This only applies if you are running a db server on a seperate linux device, of course.

 

Coordinator
Jan 9, 2012 at 10:33 AM
Edited Jan 9, 2012 at 10:33 AM

Hi Dan,

We are aware of this, when we did the first mysql scripts we didn't take care of the case sensitivity... There is a flag you can set up, we included this instructions in the installation guide.

We know that we should be supporting case sensitive operative systems (without changing a flag in the mysql configuration), I added the task: http://nearforums.codeplex.com/workitem/20052

Would you like to help us with this task?

Kind regards,

Jorge