Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com

Collation is a configuration level setting in the MSSQL. It directs how the character data will be handled by the MsSQL Database within the server, database, or column level.

You can change the Database Collation using the SQL Commands as well as from GUI. Following are the steps to change the Collation for a Database on MsSQL.

Note: Consult your Database/Web Developer before making these changes.

 

  1. Login to the SQL Server using the SQL Management Studio.

  2. Right-Click on the Database name and select the Properties. It will open the Database Properties Dialogue Box.

    sql-database.png

  3. Click on the Options. You will see the Collation field with the drop-down.

    sql-collation.png

  4. Select your required Collation and click to the OK Button.

You have changed the Database Collation successfully.

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

Choosing Between SQL Server 2012 and SQL Server 2014

If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to...
Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...
How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...
How to configure MSSQL server default language configuration option?

Recently, we faced strange issue wherein one of our customers was capturing error messages coming...
How to restore MSSQL database from SQL Server Management Studio?

This article will guide you on how to restore MSSQL database from SQL Server Management Studio....

Powered by WHMCompleteSolution