data truncation error on null field
<p>I am cleaning my db of obsolete values, and I want to set a column is_promotion to null : </p>

<pre><code>update my_table 
set    is_promotion = null 
where  is_promotion = 0
</code></pre>

<p>And I have this error</p>

<blockquote>
  <p>Data Truncation error occurred on a write  of column 0Data was 0 bytes long and 0 bytes were transferred.</p>
</blockquote>

<p>Note that my_table have this structure for my column is_promotion, so it should be nullable : </p>

<pre><code>  `is_promotion` varchar(10) DEFAULT NULL,
</code></pre>

<p>Please note that I saw some posts about data truncation, but all of them were because column wasnt formatted for the provided value, in my case my column is nullable</p>