title: Creating uppercase MySQL table names with PHP
body: <p>I'm trying to create a table with the name <code>ID1</code> using this function:</p>
  
  <pre><code>public function createIDTable($IdNumber)
  {
      $sql = "CREATE TABLE `Database`.`ID$IdNumber` (`Names` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL)";
  
          $query = mysql_query($sql)or die (mysql_error());
          return "Sucess";
  }
  </code></pre>
  
  <p>It creates the table, but the names are always lowercase, like <code>id1</code>. I need <code>ID1</code> - how can I do it?</p>