How to set collation for a specific Column in a Sequelize model?

Question

How to set collation for a specific Column in a Sequelize model?

I tried this:

name: {
  type: Sequelize.STRING,
  allowNull: false,
  collate: 'utf8_general_ci'
},

Apparently it doesn't work. Any other ideia?

Achlamydeous

do you want to map the column named "name", in this case? – Ku

yes, or for any other. – Sergent

sorry @Tiago Bértolo I thought your problem was in the construction of the model. Had not read the word "collate" – Ku

No problem mate. Thanks for trying. – Sergent

Try this Sequelize.STRING + ' CHARSET utf8 COLLATE utf8_general_ci' in your type – Ku

Didn't work! Nice attempt though! :D – Sergent

hum... this works for me – Ku

What your sequelize version? Your different charset is only for this column or all database? – Ku

Answer 1

There are several things you can do to support:

Table level:

sequlize.define('table', {

}, {
    charset: 'utf8',
    collate: 'utf8_general_ci'
})

Column level:

sequelize.define('table', {
    column: Sequelize.STRING + ' CHARSET utf8 COLLATE utf8_general_ci'
})

Database level:

let sequelize = new Sequelize('database', {
    dialectOptions: {
        charset: 'utf8',
        collate: 'utf8_general_ci',
    }
});

Alfeus

Ok... Let's try, at some point, we can get it right. Set the define in sequelize... whith the column level sample. Outside your model – Ku

Answer 2

What It worked for me

await queryInterface.sequelize.query(`
    ALTER TABLE files
    MODIFY COLUMN original_name VARCHAR(255)
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_general_ci NOT NULL;
`);

Ariannaarianne