Fix #13178 - Issues with uppercase table and database names

Fixes: #13178
[ci skip]
Signed-off-by: William Desportes <williamdes@wdes.fr>

1 files changed, 9 insertions, 0 deletions

diff --git a/tbl_create.php b/tbl_create.php
index 503b168a32..1d9c30cc3c 100644
--- a/tbl_create.php
+++ b/tbl_create.php
@@ -62,6 +62,15 @@ $action = 'tbl_create.php';
  * The form used to define the structure of the table has been submitted
  */
 if (isset($_POST['do_save_data'])) {
+    // lower_case_table_names=1 `DB` becomes `db`
+    if ($GLOBALS['dbi']->getLowerCaseNames() === '1') {
+        $db = mb_strtolower(
+            $db
+        );
+        $table = mb_strtolower(
+            $table
+        );
+    }
     $sql_query = $createAddField->getTableCreationQuery($db, $table);
 
     // If there is a request for SQL previewing.