All Products
Search
Document Center

ApsaraDB for MyBase:Change the character set collation of system databases

Last Updated:Jul 14, 2023

This topic describes how to change the character set collation of system databases after you create an ApsaraDB MyBase for SQL Server instance in a dedicated cluster. ApsaraDB for MyBase provides four system databases: master, msdb, tempdb, and model.

Background information

By default, the character set collation used by an ApsaraDB MyBase for SQL Server instance is Chinese_PRC_CI_AS.

Prerequisites

No databases other than system databases are deployed in your ApsaraDB MyBase for SQL Server instance. Otherwise, you cannot change the character set collation.

Note

When you change the character set collation of system databases, the instance is restarted. During an instance restart, the instance is unavailable.

Procedure

  1. Log on to the ApsaraDB for MyBase console.

  2. In the upper-left corner of the page, select a region.

  3. In the left-side navigation pane, choose Instances > SQL Server.

  4. Find the account whose permissions that you want to modify, and click Edit Permissions in the Actions column.
  5. In the left-side navigation pane, click Databases.

  6. On the Databases page, click Change Character Set Collation and Time Zone.

  7. In the dialog box that appears, configure the parameters.

    Change the character set collation and the time zone of system databases
  8. Click OK.

    Note

    In the left-side navigation pane of the instance details page, click Basic Information. On the page that appears, view the changed character set collation. If you want to change the character set collation of a user database that you create, run the alter database <Self-managed database name> collate <Character set collation> command.