title: In SQL, can't set a binary to 1
body: <p>I have created a table in MySQL with a binary field name 'active' and set to NULL by default.</p>
  
  <p>But when I want to update it with this command:</p>
  
  <pre><code>$update_users = $bdd -&gt; query("UPDATE users SET `active` = 1 WHERE `id` = '$data1' LIMIT 1") or die(mysql_error());
  </code></pre>
  
  <p>The field is updated to 31 ! and not to 1.</p>
  
  <p>I have also tried </p>
  
  <pre><code>SET `active` = true
  </code></pre>
  
  <p>but same result.</p>
  
  <p>p.s: I have set 'active' using phpMyAdmin interface (no SQL statement), but here are the values of this field: Type => binary(1), Null => yes, Defaut => NULL</p>