title: mysql - "column cannot be null"
body: <p>as you see in the title, even if i removed "not null" feature from the related field, it still doesn't let me to insert null value for that field although the field is nullable!</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>EDITED </p>
  
  <h1>Create:</h1>
  
  <pre><code>CREATE TABLE `review` (
  ..
  `RATING` int(11) DEFAULT NULL,
  ..
  (`CATALOG_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=31625 DEFAULT CHARSET=latin5 ROW_FORMAT=DYNAMIC
  </code></pre>
  
  <h1>Query:</h1>
  
  <pre><code>INSERT INTO review (RATING,..) VALUES (null,..);
  </code></pre>
  
  <h1>Error message:</h1>
  
  <pre><code>Error: Column 'RATING' cannot be null
  SQLState:  23000
  ErrorCode: 1048
  </code></pre>
  
  <p>I also try to insert without RATING in the insert query, even if it is default null and nullable field, it gives the same error message and never inserts the field.</p>