Whats SQL Server NVARCHAR(max) equivalent in MySQL? Using SQL Server you just have to give the "MAX" parameter to the length of a text data type, but in MySQL there's no such a thing.

According to Ispirer:


  "n" is the maximum number of characters, optional
  
  Range:    1 ⇐ n ⇐ 21845 (65535 bytes is the maximum row size shared among all columns)


Does it mean that:

[SQL Server] "NVARCHAR(MAX)" == [MySQL]"NVARCHAR(N)"


Or do i have to say NVARCHAR(21845) as NVARCHAR(MAX) 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.