Embedded Files
We are migrating our support portal. You can reach eMagicOne support team via email: support@emagicone.com
The error occurs only if you are using Bridge connection or Connector mudule.
Important! Local Database (MadiaDB or MySQL on Windows) does not support Uppercases.
It is not recommended to create database names like:
Prefix_databasename
preFix_databasename
dataBasename
If you already have one, do not use Bridge connection or Connector module. The only available connection is Direct connection in this case.
Recomendation: Use Direct connection if your database name or prefix contains Uppercase.
Why you cannot use the uppercase in database name or prefix?
In MySQL/MariaDB, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Triggers also correspond to files. Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database, table, and trigger names.
This means such names are NOT case-sensitive in Windows, but are case-sensitive in most varieties of Unix (server database).
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names.
See official documentation for details:
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
Also you may encounter difficulties if you want to transfer tables between platforms that differ in file system case sensitivity if you keep upper cases.
So it is not recommended to use upper cases in database names or prefixes, especially of local databases are used (for bridge we are using local database stored on Windows). The only available connection is Direct connection.
Report abuse