[Info] Changing database collation in MSSQL

Article ID: 871 
Last Review: Oct,6 2008
Author: Basalyko Roman APPLIES TO:
  • Plesk 6.5 for Windows
  • Plesk 7 for Windows
  • Plesk 7.5.x for Windows
  • Plesk 7.5.6 for Windows
  • Plesk 7.5.5 for Windows
  • Plesk 7.6.x for Windows
  • Plesk 7.6.1 for Windows
  • Plesk 8.1.0 for Windows
  • Plesk 8.1.1 for Windows
  • Plesk 8.1 for Windows
  • Plesk 8.1.1.2 for Windows
  • Plesk 8.2 for Windows

Resolution

The following query can be used:

ALTER DATABASE database_name COLLATE collation_name

The current collation and other properties of the database can be retrieved using the following query:

sp_helpdb database_name
Subscription for this article changesSubscription for this article changes

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
captcha *Please type the code you can see.
* - required fields