MySQL - Table names case problem

[softlab]

Hi.

 

I wrote some SQL statements, referencing table names in uppercase. When my java code tries to execute them, an error is send, telling that table name does not exist. I also saw that in phpMyAdmin table names are in lowercase.

 

Is there a way to reference them in uppercase (or in a not case sensible way)?

 

Thanks

[Krydos]

Mysql itself isn't case sensitive. Windows is not case sensitive so mysql on windows isn't case sensitive. Linux is case sensitive so mysql on linux is case sensitive. A table named TEST is different from test on linux. I just always do everything in lowercase to make it consistent. Mysql has a hard enough time without me yelling at it in all caps.

[softlab]

Ok, thanks.

 

I renamed all the tables in uppercase and now it's ok.

[Krydos]

"Stop yelling at me!", mysql probably.

[michaeltim]

I strongly recommend to always use lowercase names.