Changing the default collation of SQL Server Instance on Windows can be a complicated, time-consuming and painful task. But, SQL Server on Linux provides very interactive and handy option to modify the collation of SQL Server instance. All you need to follow just a few steps to change the collection of SQL Server Instance rest everything will be done automatically.
In this post, we will follow a step-by-step process of changing the collection setting of SQL Server Instance on Linux system.
Change the collation of SQL Server Instance
- Connect to SQL Serer on Linux Instance using SSMS and Verify the current collation of the Server.
- Connect to your Linux machine as root user
Syntax: sudo -i
- Run the mssql-conf utility to set new collation with set-collation parameter
Syntax: /opt/mssql/bin/mssql-conf set-collation
- Setting up the new collation will cause SQL Server to restart
- Provide the new collation name
- And Done! It was never so easy to change the collation of SQL Server Instance.
- Let’s verify the new collection of SQL Server Instance
It is really the easiest way to change the collation of SQL Server Instance. Hope, you enjoyed changing the collation of your SQL Server Instance on Linux system.
7 thoughts on “Modify the collation of SQL Server Instance on Linux”
I can not change to Cyrillic_General_CI_AC
Can you please share the error which you are getting?
user@ubuntu:~$ sudo /opt/mssql/bin/mssql-conf set-collation
Enter the collation: Cyrillic_General_CI_AS
Configuring SQL Server…
This is an evaluation version. There are [156] days left in the evaluation period.
After this message, nothing changes
Let me test it out this and get back to you
You did not check
I tested this scenario. Yes, it was throwing the same error to me. I verified with Microsoft team and they confirmed that CTP2.1 got bug for this collation, it will be fixed in the upcoming release.
Thank you