MySQL longtext analog in Microsoft SQL?

Question

I am new to Microsoft SQL and I am trying to import a database from MySQL. The only problem I encountered is that the MySQL database uses the longtext data longtext for multiple columns of the table.

Which Microsoft SQL data type is similar to MySQL longtext ?

Thank you for your time.

Answer 1

Microsoft SQL Server has NTEXT and NVARCHAR(MAX) , which are very similar; NVARCHAR(MAX) (or VARCHAR(MAX) if you do not need to handle internationalization) it is recommended to use earlier NTEXT (and TEXT again if you do not need to store anything but one code page.)