The Ultimate Guide to High Availability with MariaDB

JavaEE application with Oracle DB to MariaDB - case sensitive DB objects

Is there any option when creating an instance of MariaDB, or something in the JDBC-Connector setting, where we can disable case sensitive handling of DB objects like tables, fields. Our data-access layer code-base is large and if we are to do a find and replace on SQL statements with respect to making it case sensitive, it is going to be a daunting task. We are new to MySQL or MariaDB, sorry if we are missing something related to MariaDB/ConnectorJ basic understanding.

Answer Answered by Brian Evans in this comment.

This is a server setting.

Please see Identifier Case-sensitivity

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.