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
  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.