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.

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

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 Cloud Disk Edition
  • Your RDS instance does not belong to the shared instance family or a dedicated cluster. For more information, see 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

Your RDS instance is unavailable during the change process. 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 page that appears, 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.
  4. In the dialog box that appears, select a new time zone, a new character set collation, or both. Then, click OK. Change Character Set Collation and Time Zone dialog box
  5. Go to the Basic Information page and view the new character set collation and time zone. View the new character set collation and time zone

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