Digiweb Support :: Change your database collation

Knowledgebase Home

Search the Knowledgebase

Browse by Category

Knowledgebase Home > Hosting and Domains > Web Hosting > Windows Shared Hosting > Managing your SQL Database

Change your database collation

You can modify the default collation of your SQL database using a simple SQL query in your SQL management software of choice. The query you should run is as follows:

ALTER DATABASE yourdatabase_name COLLATE collation_of_choice

If you were to run this on a database named, winuser_mydb to change the collation to Latin1_General_CI_AS this would work as follows:

ALTER DATABASE winuser_mydb COLLATE Latin1_General_CI_AS

If you are running this command on an installed and established database you will need to set your database in Single User mode to run this query, once you have run the query you can set the database in multi user mode, to this, you would do the following:

ALTER DATABASE winuser_mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE winuser_mydb COLLATE Latin1_General_CI_AS
ALTER DATABASE winuser_mydb SET MULTI_USER

No related articles were found.