How do I change my SQL Server database’s collation?

You can easily do this from within the Windows Control Panel. Follow the steps below to set your database’s collation.

  1. Login to https://panel.aspnix.com/
  2. Click SQL Server under “Databases”
  3. Click the SQL Server database you wish to change the collation for
  4. Click the “Database Collations” panel / drop down
  5. Select the collation required for your database
  6. Press the “Save” button

[singlepic id=61 w=320 h=240 float=]

You’re done! You may also set the collation when creating a new SQL Server database. The “Database Collations” panel is not hidden when creating a SQL Server database, you may use the default option or select a different collation and press “Save”.

If you have any questions, please contact our support department.