Can anyone offer advice?

I have come across a MySQL database on Linux with duplicate table names - "Accounts" 
and "accounts". This seems fine on Linux, but does not transfer to the Windows 
environment - it is rejected because of the duplicate name. However I do see that 
Column Names have to be unique in both environments.

Q. Is there some sort of practical advantage for having case sensitive table names in 
Linux, or is this a design "shortcoming"? Postgress rejects duplicate table names.

Thanks
Tim Hayes

Reply via email to