title: MySql array type and default value
body: <p>I need add field with default value like that </p>
  
  <pre><code>`setting_notification` = 'a:2:{s:19:"other_notifications";i:1;s:21:"message_notifications";i:0;}' 
  
  ALTER TABLE app_users ADD setting_notification tinytext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)'
  </code></pre>
  
  <p>How can do this ?</p>
  
  <p>I try this </p>
  
  <pre><code>ALTER TABLE app_users 
  ADD setting_notification LONGTEXT CHARACTER SET utf8 
  DEFAULT 'a:2:{s:19:"other_notifications";i:1;s:21:"message_notifications";i:0;}'  
  COMMENT '(DC2Type:array)'
  </code></pre>
  
  <p>And have error</p>
  
  <pre><code> [Err] 1101 - BLOB, TEXT, GEOMETRY or JSON column 'setting_notification' can't have a default value
  </code></pre>
  
  <p>and try like that </p>
  
  <pre><code>ALTER TABLE app_users 
  ADD setting_notification tinytext 
  DEFAULT "a:2:{s:19:\"other_notifications\";i:1;s:21:\"message_notifications\";i:0;}" 
  COLLATE utf8_unicode_ci 
  NOT NULL COMMENT '(DC2Type:array)'
  </code></pre>
  
  <p>still have error </p>
  
  <pre><code>[Err] 1101 - BLOB, TEXT, GEOMETRY or JSON column 'setting_notification' can't have a default value
  </code></pre>
  
  <p>sql version</p>
  
  <pre><code>mysql&gt; SELECT VERSION();
  +-------------------------+
  | VERSION()               |
  +-------------------------+
  | 5.7.16-0ubuntu0.16.04.1 |
  +-------------------------+
  1 row in set (0,01 sec)
  </code></pre>