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.
Table name case insensitive
-
- Devart Team
- Posts: 271
- Joined: Wed 23 Jan 2013 11:21
Re: Table name case insensitive
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.
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.