How to define an NVARCHAR(MAX) field with sequelize?

Question

Using node.js and sequelize vis-a-vis MSSQL, how do I define an NVARCHAR(MAX) field?

Answer 1

If you give the datatype as TEXT in Sequelize It will automatically convert that field to NVARCHAR(MAX) for SQL Server database.

I could not find this in the documentation

But it is mentioned in Sequelize github repository from line 79 to 90.

Pasting here the code snippet:

    TEXT.prototype.toSql = function toSql() {
    // TEXT is deprecated in mssql and it would normally be saved as a non-unicode string.
    // Using unicode is just future proof
    if (this._length) {
      if (this._length.toLowerCase() === 'tiny') { // tiny = 2^8
        warn('MSSQL does not support TEXT with the `length` = `tiny` option. `NVARCHAR(256)` will be used instead.');
        return 'NVARCHAR(256)';
      }
      warn('MSSQL does not support TEXT with the `length` option. `NVARCHAR(MAX)` will be used instead.');
    }
    return 'NVARCHAR(MAX)';
  };

As you can see SQL Server does not support TEXT field so it will convert it to NVARCHAR(MAX)