Use 'N at row start in SQL Server bulk statement

I am inserting data from a csv file into a SQL S开发者_如何学JAVAerver table using the bulk statement, there is some German characters in file, and I want to use 'N at start of the row (as we use it in insert statement).

How can I do this?

Thanks

You probably don't need N: this is for nvarchar columns.

The standard Latin1_General_CI_AS collation (includes varchar codepage) supports German characters already in varchar columns.