In this article, you will learn how to use a Unicode character set in SQL, including how to choose the right data type, how to insert and query Unicode data, and how to avoid common pitfalls.

Use unicode character format to import or export data (SQL Server) [!INCLUDE SQL Server Azure SQL Database Synapse Analytics PDW ] Unicode character format is recommended for bulk transfer of data ...

The sql_variant data that is stored as a SQLVARIANT in a Unicode native-format data file operates in the same manner as it does in a native-format data file, except that char and varchar values are ...

In SQL, when dealing with Unicode data, use the right data types like NVARCHAR or NCHAR. To insert Unicode data, add an N before strings like N'' to indicate it's Unicode.