Performance impact using N prefix while inserting the unicode data

[amollokhande1]

Hi,

I would like to know whether is any performance impact on sql server while using N as prefix in the sql query. For instance if have used following query
to insert the data in fields of CHAR, VARCHAR and TEXT datatype

Insert into Globalization values(N'Amol', N'Amol',N'Amol' ,N'Amol',N'Amol ')

then is there any issue or performance loop hole.

Regards
Amol Lokhande