Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.
New Best Practices Whitepaper Published: The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode

When a business grows internationally, its database system must support multilingual characters in tables. Businesses that previously needed to manage only non-Unicode information must now support database tables that include non-Unicode data types such as CHAR or VARCHAR. As the business grows internationally, it must alter its database system to support Unicode data types. It may also need databases that have different collations across several servers.

 

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL_bestpract_CollationChange.docx

 

 

Posted: Thursday, December 06, 2007 11:07 PM by Sanjay Mishra

Comments

MSDN Blog Postings » New Best Practices Whitepaper Published: The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode said:

PingBack from http://msdnrss.thecoderblogs.com/2007/12/06/new-best-practices-whitepaper-published-the-impact-of-changing-collations-and-of-changing-data-types-from-non-unicode-to-unicode/

# December 6, 2007 7:40 PM

Windows Vista News said:

Did you see the post at blogs.msdn.com

# December 6, 2007 8:00 PM

Troubleshooting and Tips - Cindy Gross said:

<p>Sometimes you need to change the collation of a database after you have created it and populated it with objects and data. So how do you change the collation?</p> ...

# September 11, 2008 12:08 AM
Anonymous comments are disabled
Page view tracker