Symptoms. When you use Microsoft SQL Server 2012 or SQL Server 2014, the bulk copy program (bcp) utility (Bcp.exe) may crash. Note This issue occurs on a rare condition. Resolution. The issue was first fixed in the following cumulative update of SQL Server. Cumulative Update 2 for SQL Server 2014 SP1 /en-us/help/3075950.

To import UTF-8 data to SQL Server, use the BCP utility and run the following command: bcp table_name in "drive:path\file_name" -c -C 65001 To export UTF-8 data to SQL Server, use the BCP utility and run the following command: bcp table_name out "drive:path\file_name" -c -C 65001 This update is included in the following service pack for SQL Server:

KB3166545 - FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows - Microsoft Support.

Summary. This update improves SQL Server 2014 functionality by adding support for importing and exporting UTF-8 data to and from SQL Server, as follows: UTF-8 import support is added to the BCP utility and to the BULK INSERT Transact-SQL command. UTF-8 export support is added to the BCP utility.

Cause. This problem occurs because the following components are installed in the wrong location: SQL Powershell (Sqlps.exe) Log shipping executable (SQLLogship.exe) Bcp.exe and other components. The jobs that are created by using one of these components are located in different locations on both nodes.

292648 FIX: Bcp.exe ignores -R regional settings switch when using format file (-f) 328514 FIX: Binding an output parameter of an Oracle stored procedure to adBSTR results in an incorrect value.

This article describes Cumulative Update package 1 (CU1) (build number: 12.0.6205.1) for Microsoft SQL Server 2014 Service Pack 3 (SP3). This update contains fixes that were released after the initial release of SQL Server 2014 SP3.

This article describes cumulative update package 5 (Build number: 12.0.4439.1) for Microsoft SQL Server 2014 Service Pack 1 (SP1). This update contains fixes that were released after the release of SQL Server 2014 SP1.

This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. The updates in this package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for.

How to obtain this cumulative update package. The following update is available from the Microsoft Download Center: Download the latest cumulative update package for Microsoft SQL Server 2014 Service Pack 1 (SP1) now. If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.