Using Unicode with bcp and OPENROWSET

To prevent character loss when you use the bcp utility to copy data between servers that have different code pages, you can specify that the data be copied in Unicode format. For more information, see Copying Data Between Different Collations.

Unicode format can also be specified when you use OPENROWSET to access external data. For more information, see OPENROWSET (Transact-SQL).