title: MySQL field DATETIME truncates ISO8601
body: <p>Having MySQL/MariaDB table created like</p>
  
  <pre><code>CREATE TABLE `testTable` (
    `id` int(11) NOT NULL,
    `timeinfo` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>And inserted with full ISO8601 value like this:</p>
  
  <pre><code>MariaDB [test]&gt; INSERT INTO testTable VALUES (1, '2500-12-31T00:00:00.000Z');
  Query OK, 1 row affected, 1 warning (0.00 sec)
  
  MariaDB [test]&gt; show warnings;
  +---------+------+-----------------------------------------------+
  | Level   | Code | Message                                       |
  +---------+------+-----------------------------------------------+
  | Warning | 1265 | Data truncated for column 'timeinfo' at row 1 |
  +---------+------+-----------------------------------------------+
  1 row in set (0.00 sec)
  
  MariaDB [test]&gt; select * from testTable;
  +----+---------------------+
  | id | timeinfo            |
  +----+---------------------+
  |  1 | 2500-12-31 00:00:00 |
  +----+---------------------+
  1 row in set (0.01 sec)
  </code></pre>
  
  <p>I don't exactly see what is being truncated, the "Z" as in ZULU TimeZone ?</p>
  
  <hr>
  
  <p>Is it possible to contain the information fully in MySQL/MariaDB field type?  </p>
  
  <p>If so which field data type should be used?</p>