开发者

Use 'N at row start in SQL Server bulk statement

开发者 https://www.devze.com 2023-04-11 23:57 出处:网络
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

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号