title: MYSQL Table Alignment Formatting
body: <p>Im currently working on an assignment in MYSQL where my scenario is to create a database for the army (i picked the scenario, dont ask why). My problem however, is that after creating the table and populating it, the format of the table is displayed of when i do a <code>SELECT</code> command. Somthing like this:</p>
  
  <pre><code>+---------------------------------------------+----------+----------------+----------------+------------+
  | Name                                        | Codename | Type           | FOB            | Combatants |
  +---------------------------------------------+----------+----------------+----------------+------------+
  | 12 Régiment blindé du Canada              | Adsum    | Armour         | CFB Valcartier |          9 |
  | 5 Régiment d'artillerie légère du Canada | Ubique   | Artillery      | CFB Valcartier |         12 |
  | 5 Combat Engineer Regiment                  |          | Support        | CFB Valcartier |          5 |
  | 3rd Battalion, Royal 22e Régiment          | Vipère  | Light Infantry | CFB Valcartier |          5 |
  | The Canadian Grenadier Guards               | Vipère  | Light Infantry | Montreal       |          5 |
  +---------------------------------------------+----------+----------------+----------------+------------+
  </code></pre>
  
  <p>I cant figure out why this is happening, the number of characters in each field is less then what is set when i created the table so this should not happen. Heres my table desc:</p>
  
  <pre><code>+------------+-------------+------+-----+---------+-------+
  | Field      | Type        | Null | Key | Default | Extra |
  +------------+-------------+------+-----+---------+-------+
  | Name       | varchar(50) | NO   | PRI | NULL    |       |
  | Codename   | varchar(30) | YES  |     | NULL    |       |
  | Type       | varchar(20) | NO   |     | NULL    |       |
  | FOB        | varchar(20) | NO   | MUL | NULL    |       |
  | Combatants | int(11)     | NO   |     | NULL    |       |
  +------------+-------------+------+-----+---------+-------+
  </code></pre>
  
  <p>All my other tables come out correctly aligned, so i dont know why this table is like this.</p>