Article Shows How to Maintain Database Accuracy in Any Language

If your organization needs to store data in multiple languages in one database, then you know the importance of understanding collations to maintain the readability and accuracy of your data. A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General (the Latin alphabet that Western European languages use). To find out what collation a server is currently using, you can run the sp_helpsort system stored procedure in SQL Server Query Analyzer. But what do you need to know to really manage collations? To help you, Microsoft released the article "How to transfer a database from one collation to another collation in SQL Server." The article defines collation and how to transfer a database from one collation to another in either SQL Server 2000 or SQL Server 7.0. In addition, the article includes references to other Microsoft articles that provide detailed explanations of collations and how to work with them. You can read this article at

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.