Working with Unicode Data
The topics in this section explain the Unicode character data types in SQL Server and how to use them in all aspects of database design and programming.
Explains the reasons for using Unicode and also the storage and performance trade-offs involved.
Explains measures that are required to preserve the integrity of character data when programming applications in client/server environments that vary in their Unicode-awareness.
Explains how to use Unicode to preserve the integrity of character data when you copy, import, and export data by using the bcp utility and the OPENROWSET function.
Explains the benefits of preserving XML data in the UTF-8 encoding scheme and how to force conversion to other encoding schemes.