B4J Question MySql Upper case lower case

[Fabrice La]

In my application WebApp I have 2 servers.
- Test-
- Preprod

The DataBase has been copy in between these 2 servers but some table are Lower case or Upper case
"Select * from Validation" in test server
"Select * from validation" in Preprod server

If I use MYSQL Workbench and connect to PreProd and use either :
"Select * from validation" or "Select * from Validation" The both request work.

If I use "Select * from Validation" in the B4J appli I have an error connected to Preprod server :
The Table Validation doesn't exit ....
Why

 

[Erel]

See the answers here: http://stackoverflow.com/questions/6134006/are-table-names-in-mysql-case-sensitive

 

[Fabrice La]

Thanks