title: Changing SQL Mode on Mariadb Image with docker-compose
body: <p>I have an issue with the official dockerized image of Mariadb.</p>
  
  <p>When my applications tries to make some queries I got the following error :</p>
  
  <blockquote>
    <p>DB Error: unknown error QUERY : INSERT INTO</p>
  </blockquote>
  
  <p>It seems this error comes from the SQL_MODE, which is set as follow in this image :</p>
  
  <pre><code>STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,
  NO_ENGINE_SUBSTITUTION
  </code></pre>
  
  <p>I have a normal Linux Server and with mariadb installed and i don't have this STRICT_TRANS_TABLES value in my SQL_mode. And my application is working without any problem.</p>
  
  <p>How can I remove the STRICT_TRANS_TABLES value in my container when I run docker-compose with my docker-compose file without the need of a custom dockerfile?</p>