Node,Sequelize,Mysql - 如何为模型定义排序规则和字符集？

我希望能够为模型的每个属性定义排序规则和字符集.默认排序规则是'latin1_swedish_ci',我需要'utf-8'.

任何人？TNX

在你定义sequelize的部分

var sequelize = new Sequelize('database', 'username', 'password', {
  define: {
    charset: 'utf8',
    collate: 'utf8_general_ci', 
    timestamps: true
  },
  logging:false
});

对于表级别更改

sequelize.define('songs', {
  name: DataTypes.STRING,
  link: DataTypes.STRING,
  artist: DataTypes.STRING,
  lyrics: DataTypes.TEXT,
  writer: DataTypes.STRING,
  composer: DataTypes.STRING
}, {
  charset: 'utf8',
  collate: 'utf8_unicode_ci'
});