Is there nvarchar datatype in MySql?

there is no nvarchar datatype in mysql. You have convert it to varchar.

MSSQL: nvarchar(100)
translates to
MySQL: varchar(100) character set UTF8

works as well for the text / ntext - in mysql unicode is switched on by the 'character set UTF8' option.


----

For column level you can set "character set" as follows:

create table nvarchar_test
(
_id varchar(10) character set utf8,
_name varchar(200) character set ascii
)

In the above example _id will be able to take 10 unicode characters and _name will be able to take 100 unicode characters (each unicode character will evaluate to two ascii character)