Convert nvarchar(max) to mysql data type
MySQL
1
Posts
1
Posters
4
Views
1
Watching
-
Hello everybody! I've migrated my mssql database to mysql using SQLWays. In my stored procedures I use several variables which are supposed to hold a great amount of data so I declared them in mssql as nvarchar(max), however in mysql they are migrated as NATIONAL VARCHAR(4000), which obviously limits them to hold up to 4000 characters, so my code doesn't work as I need it to. What I need to know is the right data type to use so that I can achieve the great amount of data storage. If someone can help me out with this, I will really appreciate it. Thanks in advance,
Kenia