First Example gives me Error id too long

[ilyago]

UnhandledPromiseRejectionWarning: SequelizeDatabaseError: Data too long for column 'id' at row 1

[HyperCharlie]

Still getting this!

[rootelement]

DISCLAIMER - I got this working before i used this sequelize-binary-uuid plugin. But I did get that Data too long error and this worked for me. I'm now trying this plugin and will let you know if I have problems.

When I do the alter (i'm using DBeaver), I had to do a binary with a length which DBeaver wouldn't let me do out of the box:

ALTER TABLE tablename MODIFY COLUMN id binary(36) NOT NULL;

Then in the model, I did:

return sequelize.define(
    'tablename',
    {
      id: {
        type: DataTypes.UUIDV4,
        allowNull: false,
        defaultValue: Sequelize.UUIDV4,
        unique: 'uuid',
        primaryKey: true,
        get() {
          let value = this.getDataValue('id');
          if (Buffer.isBuffer(value)) {
            value = value.toString('utf8');
          }

          return value;
        },
      },