Devart Forums

Hi, all.
I'm using MySql database runnings on vm with linux debian.
I changed tablename JNTICKET to jnticket.
After this change I've sql error as "table JNTICKETS doesn't exists".
Maybe devart dbx driver usese an uppercase for table name?
Note that is not critical question.
Best.

Hello.

Devart dbExpress driver for MySQL does not use uppercase for table name.
By default, table aliases are case sensitive on Unix (Linux, Ubuntu), but it is not so on Windows or Mac OS X. For more detailed information please read the MySQL reference manual ( http://dev.mysql.com/doc/refman/5.0/en/ ... ivity.html ).
When working on Unix OSs (Linux, Ubuntu, etc.), SQL queries should be written considering the case of the characters in names of tables, databases, triggers, etc.