sql server - Do I have use the prefix N in the "insert into" statement for unicode?

Question

Like:
insert into table (col) values (N'multilingual unicode strings')

I'm using SQL Server 2008 and I already use nVarChar as the column data type.

Answer 1

You need the N'' syntax only if the string contains characters which are not inside the default code page. "Best practice" is to have N'' whenever you insert into an nvarchar or ntext column.