title: Mysql error BLOB, TEXT, GEOMETRY or JSON colum cant have default value
body: <p>My vps linux ubuntu is
  Server type: MySQL
  Server version: 5.7.33 ubuntu0.18.04.1 - (Ubuntu)
  Apache/2.4.29 (Ubuntu)
  Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 -
  PHP version: 7.2.24-</p>
  <p>Trying to add a column in my database but im getting error
  I tried that on windows xampp its work without any problem</p>
  <pre><code>ALTER TABLE users ADD COLUMN house LONGTEXT NOT NULL DEFAULT '{&quot;owns&quot;:false,&quot;furniture&quot;:[],&quot;houseId&quot;:0}';
  </code></pre>
  <p>Error</p>
  <pre><code>SQL query:
  
  
  ALTER TABLE users ADD COLUMN house LONGTEXT NOT NULL DEFAULT '{&quot;owns&quot;:false,&quot;furniture&quot;:[],&quot;houseId&quot;:0}'
  MySQL said: Documentation
  
  #1101 - BLOB, TEXT, GEOMETRY or JSON column 'house' can't have a default value
  </code></pre>