对于RDS for SQL Server 2012/2016版本的实例,您可以修改系统库的字符集排序规则和时区。系统库包括master、msdb、tempdb和model。

  • 默认的字符集排序规则:Chinese_PRC_CI_AS
  • 默认的时区:China Standard Time
  • 关于可选择的字符集排序规则和时区,请根据本文的操作步骤,在控制台上进行查看。

前提条件

  • 实例类型为RDS for SQL Server 2012/2016版本。
  • 实例中没有任何用户数据库(即您创建的数据库,非系统数据库)。
    说明 如果是刚删除实例中的数据库,删除任务可能还在备实例中等待执行,为避免冲突,前请确定主备实例均没有数据库后再修改字符集排序规则与时区。

注意事项

修改期间,实例将处于不可用状态。修改时区需要大约1分钟,修改字符集排序规则需要2到10分钟。

操作步骤

  1. 登录RDS管理控制台
  2. 在页面左上角,选择实例所在的地域。
    选择地域
  3. 找到目标实例,单击实例ID。
  4. 在左侧导航栏中点击数据库管理
  5. 单击修改字符集排序规则与时区
    说明 仅当实例类型为RDS for SQL Server 2012或以上版本,以及数据库管理页面没有显示任何数据库时,才会显示修改字符集排序规则与时区按钮。


  6. 在弹出的对话框中,选择时区或字符集排序规则,或两者都选择,然后单击确定
  7. 可以在实例的基本信息页面查看修改后的字符集排序规则与时区。

时区与UTC偏移量对照表

时区 标准时间偏移 备注
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