Fabrice La Active Member Licensed User Longtime User Jun 8, 2014 #1 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
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 B4X founder Staff member Licensed User Longtime User Jun 8, 2014 #2 See the answers here: http://stackoverflow.com/questions/6134006/are-table-names-in-mysql-case-sensitive Upvote 0
See the answers here: http://stackoverflow.com/questions/6134006/are-table-names-in-mysql-case-sensitive
