title: MySQL ERROR 1265: Data truncated for column
body: <p>I can't figure out why I'm getting this message. I'm using MySQL Workbench and am editing the values in an ENUM field that connects to a dropdown choice in my app.</p>
  <p>Everything seems to be fine. I've searched on this error and all I find refers to datatype mismatches but, in this instance, that's not possible with ENUM when feeding it an array of string values.</p>
  <p>Here's the SQL</p>
  <pre><code>Executing:
  ALTER TABLE `mydbase`.`average_monthly_expenses` 
  CHANGE COLUMN `expense_category` `expense_category` ENUM('Home', 'Healthcare', 'Child care', 'Groceries and supplies', 'Eating out', 'Utilities', 'Telecomms', 'Laundry and cleaning', 'Clothes', 'Education', 'Entertainment gifts vacation', 'Auto and transportation', 'Insurance', 'Savings and investments', 'Charitable contributions', 'Itemized monthly payments') NULL DEFAULT NULL ;
  
  Operation failed: There was an error while applying the SQL script to the database.
  ERROR 1265: Data truncated for column 'expense_category' at row 1
  SQL Statement:
  ALTER TABLE `mydbase`.`average_monthly_expenses` 
  CHANGE COLUMN `expense_category` `expense_category` ENUM('Home', 'Healthcare', 'Child care', 'Groceries and supplies', 'Eating out', 'Utilities', 'Telecomms', 'Laundry and cleaning', 'Clothes', 'Education', 'Entertainment gifts vacation', 'Auto and transportation', 'Insurance', 'Savings and investments', 'Charitable contributions', 'Itemized monthly payments') NULL DEFAULT NULL
  </code></pre>
  <p>Any suggestions are very welcome</p>