title: SequelizeDatabaseError Data truncated for column position at row 4
body: <p>I am getting a <code>SequelizeDatabaseError Data truncated for column 'position' at row 4</code> while sending an update request as below: Any advise on how to fix the database error ? </p>
  
  <p>Executing (default): UPDATE <code>user</code> SET <code>photo</code>=?,<code>name</code>=?,<code>email</code>=?,<code>phonenumber</code>=?,<code>position</code>=?,<code>password</code>=?,<code>updatedAt</code>=? WHERE <code>email</code> = ?
  SequelizeDatabaseError: Data truncated for column 'position' at row 4
      at Query.formatError (C:\Project\soccerpep\node_modules\sequelize\lib\dialects\mysql\query.js:244:16)
      at Execute.handler [as onResult] (C:\Project\soccerpep\node_modules\sequelize\lib\dialects\mysql\query.js:51:23)</p>
  
  <pre><code>module.exports = function(sequelize, DataTypes) {
      return sequelize.define('user', {
          name: {
              type: DataTypes.STRING(30),
              allowNull: false
          },
          email: {
              type: DataTypes.STRING(100),
              allowNull: false
  
          },
          phonenumber: {
              type: DataTypes.STRING(50),
  
          },
          id: {
              type: DataTypes.INTEGER(10).UNSIGNED,
              allowNull: false,
              primaryKey: true,
              autoIncrement: true
          },
          password: {
              type: DataTypes.STRING(50),
              allowNull: false
          },
          privilege: {
              type: DataTypes.ENUM('PLAYER','ADMIN'),
  
          },
          photo: {
              type: DataTypes.STRING(30),
  
          },
          position: {
              type: DataTypes.ENUM('FORWARD','MID-FIELD','DEFENDER','GK'),
  
          }
      }, {
          tableName: 'user'
      });
  };
  </code></pre>
  
  <p><code>server.js</code></p>
  
  <pre><code>const UserModel = userSchema(sequelize, DataTypes);
  
  app.put('/service/profile', async (req, res, next) =&gt; {
  
    try {
      const userEmail = req.query.email;
      var selector = { 
        where: { email: userEmail }
      };
      const updatePlayer = await UserModel.update(req.body, selector);
      console.log("Server side update method log:" + updatePlayer);
      res.status(200).json({ success: true });
    } catch (err) {
      return next(err);
    }
  });
  </code></pre>