Whats SQL Server NVARCHAR(max) equivalent in MySQL?
According to this MySQL document the LONGTEXT datatype in MySQL is 4 Gigabytes.  

http://wiki.ispirer.com/sqlways/mysql/data-types/longtext

Note that the number of characters depends on the encoding.