如何设置SQL Server Bulk语句的编码参数? [英] How to set encoding parameter for SQL Server Bulk statement?

问题描述

我编写了以下SQL Server批量脚本:

I wrote this SQL Server Bulk script:

BULK INSERT dbo.test
   FROM 'd:\1.csv'
   WITH(
        FIELDTERMINATOR =','

      );

但是我的CSV文件应使用以下编码系统进行编码:

But my CSV file should be encode with this encoding system:

Encoding.GetEncoding(1256)

如何将代码应用于该批量脚本?

How can I apply up code to that Bulk script?

推荐答案

CodePage是您所需要的.您可能还需要设置RowTerminator值.

CodePage is what you're looking for. You might also need a RowTerminator value set.

BULK INSERT dbo.test
FROM 'd:\1.csv'
WITH(
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n',
    CODEPAGE = '1256'
  );

这篇关于如何设置SQL Server Bulk语句的编码参数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！