SQL Server data type

Question

Please view for example.

I don't understand SQL Server data types. It has a nvarchar data type column.

I want to import that data in MySql.

What is this this column. Md5 or Base64 ?

Do you have an idea ?

Thanks.

Answer 1

As per msdn variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes. The ISO synonyms for nvarchar are national char varying and national character varying.

So it's a plain string datatype with Unicode support. I hope now it will be easy for you to find the matching datatype in MySQL.