UTF-8 encoding support for the BCP utility and BULK INSERT Transact-SQL command in SQL Server 2014 SP2

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. 

More Information

After you install this update, you can import UTF-8 data to SQL Server by running the following BULK INSERT Transact-SQL command:
BULK INSERT table_name
FROM 'drive:path\file_name'
WITH (CODEPAGE = '65001', DATAFILETYPE = 'Char')

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:


About service packs for SQL Server
About service packs for SQL Server

References

Learn about the terminology  that Microsoft uses to describe software updates.
Właściwości

Identyfikator artykułu: 3136780 — ostatni przegląd: 11.07.2016 — zmiana: 1

Opinia