This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL Server can accept data in character data format or native binary data format. Use character format when you move data between SQL Server and another application (such as Microsoft Excel) or another database server (such as Oracle or SQL Server). You can use native format only when you transfer data between instances of SQL Server.
In this Topic:
The following table indicates what data format is generally appropriate to use depending on how the data is represented and the source or target of the operation.
| Operation | Native | Unicode native | Character | Unicode character |
|---|---|---|---|---|
| Bulk transfers of data between multiple instances of SQL Server by using a data file that does not contain any extended or double-byte character set (DBCS) characters. Unless a format file is used, these tables must be identically defined. | Yes* | - | - | - |
| For sql_variant columns, use of native data format is best, because native data format preserves the metadata for each sql_variant value, unlike character or Unicode formats. | Yes | - | - | - |
| Bulk transfers of data between multiple instances of SQL Server by using a data file that contains extended or DBCS characters. | - | Yes | - | - |
| Bulk import of data from a text file that is generated by another program. | - | - | Yes | - |
| Bulk export of data to a text file that is to be used in another program. | - | - | Yes | - |
| Bulk transfers of data between multiple instances of SQL Server by using a data file that contains Unicode data and does not contain any extended or DBCS characters. | - | - | - | Yes |
* Fastest method for the bulk export of data from SQL Server when using bcp.
Use Unicode Native Format to Import or Export Data (SQL Server)
Use Unicode Character Format to Import or Export Data (SQL Server)
Import Native and Character Format Data from Earlier Versions of SQL Server
Data Types (Transact-SQL)
Specify Data Formats for Compatibility when Using bcp (SQL Server)
Training
Module
Explore data manipulation options in Azure SQL Database - Training
Learn how to invoke REST endpoints in Azure SQL Database and manipulate data using Azure Functions. Also, explore various tools and options for importing and exporting data to and from Azure SQL Database.
Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!