The datatype is nvarchar. The problem is not the datatype of the column but the literal in my sql query. If the leading N before the literal is omitted, the...

Try the following:

INSERT INTO YourTable (YourNVarCharColumn) VALUES ( N'Your korean data' );