title: MYSQL Truncated incorrect DOUBLE value
body: <p>When the SQL query below is executed:</p>
  
  <pre><code>UPDATE shop_category 
  SET name = 'Secolul XVI - XVIII' 
      AND name_eng = '16th to 18th centuries' 
  WHERE category_id = 4768
  </code></pre>
  
  <p>The following error is raised:</p>
  
  <pre><code>1292 - Truncated incorrect DOUBLE value: 'Secolul XVI - XVIII'
  </code></pre>
  
  <p>How to fix this?</p>
  
  <hr>
  
  <p><code>shop_category</code> table structure:</p>
  
  <pre><code>category_id   mediumint(8)
  name        varchar(250)
  name_eng      varchar(250)
  </code></pre>