title: mariaDB JSON support in Laravel
body: <p>I'm trying to create a json database in XAMP, while using the phpmyAdmin it showed me that I'm using mariaDB but in my <code>xamp-control panel v3.2.2</code> it shows running <code>mySQL on port 3306</code>. I'm using Laravel 5.4 framework to create the database, following is my migration which I'm trying to execute:</p>
  
  <pre><code>Schema::connection('newPortal')-&gt;create('pages', function (Blueprint $table){
      $table-&gt;increments('id');
      $table-&gt;string('title');
      $table-&gt;string('slug')-&gt;unique()-&gt;index();
      $table-&gt;json('styles')-&gt;nullable();
      $table-&gt;json('content')-&gt;nullable();
      $table-&gt;json('scripts')-&gt;nullable();
      $table-&gt;softDeletes();
      $table-&gt;timestamps();
  });
  </code></pre>
  
  <p>Now while executing this I'm getting following error:</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, <code>content</code> json null, <code>scripts</code> json null, <code>deleted_at</code> timestamp null' at line 1 (SQL: create table <code>pages</code> (<code>id</code> int unsigned not null auto_increment primary key, <code>title</code> varchar(191) not null, <code>slug</code> varchar(191) not null, <code>styles</code> json null, <code>content</code> json null, <code>scripts</code> json null, <code>deleted_at</code> timestamp null, <code>created_at</code> timestamp null, <code>updated_at</code> timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci)</p>
  </blockquote>
  
  <p>Even if I keep not null it throws the same error. I want to have json formatted data, I checked the supported version and as per the documentation json format support started from the version <code>MariaDB 10.0.16.</code> and I'm using <code>10.1.21-MariaDB</code></p>
  
  <p>Help me out in this.</p>