This topic describes how to change the character set collation and time zone of system databases on an ApsaraDB RDS for SQL Server instance. ApsaraDB RDS provides four system databases: master, msdb, tempdb, and model.

Background information

  • The default character set collation is Chinese_PRC_CI_AS.
  • The default time zone is China Standard Time.
Note
  • You can view the available character set collations and time zones in the ApsaraDB RDS console. For more information, see the "Procedure" section of this topic.
  • To change the character set collation of a self-managed database, you can run the alter database <The name of the self-managed database> collate <The character set collation that you want to use> command.

Prerequisites

  • Your RDS instance runs one of the following SQL Server versions:
    • SQL Server 2019
    • SQL Server 2017
    • SQL Server 2016
    • SQL Server 2012
    • SQL Server 2008 R2 with standard or enhanced SSDs (ESSDs)
  • Your RDS instance does not belong to the shared instance family or a dedicated cluster. For more information, see ApsaraDB RDS instance families.
  • No user databases are created on your RDS instance. User databases are different from system databases.
    Note If you have just deleted databases from your RDS instance, the deletion task may be pending on the secondary RDS instance. Before you can change the character set collation and time zone, make sure that neither your RDS instance nor its secondary RDS instance contains user databases. This prevents conflicts.

Precautions

When you change the character set collation and time zone of system databases on an RDS instance, the RDS instance is restarted. During the restart, the RDS instance is unavailable. It requires 2 minutes to 10 minutes to change the character set collation and about 1 minute to change the time zone.

Procedure

  1. Visit the RDS instance list , select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Databases.
  3. On the Databases page, click Change Character Set Collation and Time Zone.
    Note If you cannot find the Change Character Set Collation and Time Zone button, you must verify that your RDS instance meets the requirements that are described in the "Prerequisites" section of this topic.
    1
  4. In the dialog box that appears, set the Time Zone and Character Set Collation parameters. 3
  5. Then, click OK.
  6. Go to the Basic Information page and view the new character set collation and time zone. 4

Time zones and UTC offsets

Time zone UTC offset Description
Afghanistan Standard Time (UTC+04:30) Kabul
Alaskan Standard Time (UTC-09:00) Alaska
Arabian Standard Time (UTC+04:00) Abu Dhabi, Muscat
Atlantic Standard Time (UTC-04:00) Atlantic Time (Canada)
AUS Central Standard Time (UTC+09:30) Darwin
AUS Eastern Standard Time (UTC+10:00) Canberra, Melbourne, Sydney
Belarus Standard Time (UTC+03:00) Minsk
Canada Central Standard Time (UTC-06:00) Saskatchewan
Cape Verde Standard Time (UTC-01:00) Cabo Verde Is.
Cen. Australia Standard Time (UTC+09:30) Adelaide
Central America Standard Time (UTC-06:00) Central America
Central Asia Standard Time (UTC+06:00) Astana
Central Brazilian Standard Time (UTC-04:00) Cuiaba
Central Europe Standard Time (UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
Central European Standard Time (UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb
Central Pacific Standard Time (UTC+11:00) Solomon Islands, New Caledonia
Central Standard Time (UTC-06:00) Central Time (US and Canada)
Central Standard Time (Mexico) (UTC-06:00) Guadalajara, Mexico City, Monterrey
China Standard Time (UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi
E. Africa Standard Time (UTC+03:00) Nairobi
E. Australia Standard Time (UTC+10:00) Brisbane
E. Europe Standard Time (UTC+02:00) Chisinau
E. South America Standard Time (UTC-03:00) Brasilia
Eastern Standard Time (UTC-05:00) Eastern Time (US and Canada)
Georgian Standard Time (UTC+04:00) Tbilisi
GMT Standard Time (UTC) Dublin, Edinburgh, Lisbon, London
Greenland Standard Time (UTC-03:00) Greenland
Greenwich Standard Time (UTC) Monrovia, Reykjavik
GTB Standard Time (UTC+02:00) Athens, Bucharest
Hawaiian Standard Time (UTC-10:00) Hawaii
India Standard Time (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
Jordan Standard Time (UTC+02:00) Amman
Korea Standard Time (UTC+09:00) Seoul
Middle East Standard Time (UTC+02:00) Beirut
Mountain Standard Time (UTC-07:00) Mountain Time (US and Canada)
Mountain Standard Time (Mexico) (UTC-07:00) Chihuahua, La Paz, Mazatlan
US Mountain Standard Time (UTC-07:00) Arizona
New Zealand Standard Time (UTC+12:00) Auckland, Wellington
Newfoundland Standard Time (UTC-03:30) Newfoundland
Pacific SA Standard Time (UTC-03:00) Santiago
Pacific Standard Time (UTC-08:00) Pacific Time (US and Canada)
Pacific Standard Time (Mexico) (UTC-08:00) Baja California
Russian Standard Time (UTC+03:00) Moscow, St. Petersburg, Volgograd
SA Pacific Standard Time (UTC-05:00) Bogota, Lima, Quito, Rio Branco
SE Asia Standard Time (UTC+07:00) Bangkok, Hanoi, Jakarta
China Standard Time (UTC+08:00) Kuala Lumpur, Singapore
Tokyo Standard Time (UTC+09:00) Osaka, Sapporo, Tokyo
US Eastern Standard Time (UTC-05:00) Indiana (East)
UTC UTC Coordinated Universal Time
UTC-02 (UTC-02:00) Coordinated Universal Time-02
UTC-08 (UTC-08:00) Coordinated Universal Time-08
UTC-09 (UTC-09:00) Coordinated Universal Time-09
UTC-11 (UTC-11:00) Coordinated Universal Time-11
UTC+12 (UTC+12:00) Coordinated Universal Time+12
W. Australia Standard Time (UTC+08:00) Perth
W. Central Africa Standard Time (UTC+01:00) West Central Africa
W. Europe Standard Time (UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna