Table name case insensitive

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
Posts: 12
Joined: Mon 20 Aug 2012 08:47

Table name case insensitive

Post by zzzato » Mon 29 Apr 2013 07:23

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.

Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: Table name case insensitive

Post by DemetrionQ » Mon 29 Apr 2013 15:42


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 ( ... 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.

Post Reply