SQL Server Best Practices Article
Published: November, 2007
Writers: Akio Jose
Technical Reviewers: Don Vilen, Fernando Caro, Goldie Chaudhuri, Michael Wang, Sanjay Mishra, Stuart Ozer
When a business grows internationally, its database system must support multilingual characters in tables through the use of Unicode data types. This white paper explores the amount of time that it takes to change a table column from a non-Unicode data type to a Unicode data type, along with changing the collation of the database. Use this information to calculate how long it takes to alter large tables.
For more information, please refer to the The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode whitepaper.
