You can call this operation to modify the sorting rule of the character sets and the time zone of the database. This operation is deprecated.

Note This operation is deprecated.

Debugging

You can use API Explorer to perform debugging. API Explorer allows you to perform various operations to simplify API usage. For example, you can retrieve APIs, call APIs, and dynamically generate SDK example code.

Request parameters

Parameter Type Required Example Description
Action String Yes ModifyCollationTimeZone

The operation that you want to perform. Set the value to ModifyCollationTimeZone.

DBInstanceId String Yes rm-uf6wjk5xxxxxxx

The ID of the instance.

AccessKeyId String No LTAIfCxxxxxxx

The AccessKey ID that Alibaba Cloud issues to a user for service access.

Collation String No Latin1_General_CI_AS

The sorting rule of the character sets. Valid values:

  • Latin1_General_CI_AS
  • Latin1_General_CS_AS
  • SQL_Latin1_General_CP1_CI_AS
  • SQL_Latin1_General_CP1_CS_AS
  • Chinese_PRC_CS_AS
  • Chinese_PRC_BIN
  • Chinese_PRC_CI_AS
  • Japanese_CI_AS
  • Japanese_CS_AS
  • Chinese_Taiwan_Stroke_CI_AS
  • Chinese_Taiwan_Stroke_CS_AS

The system does not modify the sorting rule of the character sets by default.

Note You must specify either the Collation or Timezone parameter.
Timezone String No China Standard Time

The system time zone. The system does not modify the time zone by default.

Note You must specify either the Collation or Timezone parameter.

Response parameters

Parameter Type Example Description
Collation String Latin1_General_CI_AS

The sorting rule of the character sets.

DBInstanceId String rm-uf6wjk5xxxxxxx

The ID of the instance.

RequestId String 8EA054AF-DFA7-497D-9F57-790FFC974C0B

The ID of the request.

TaskId String 114413215

The ID of the task.

Timezone String China Standard Time

The time zone.

Examples

Sample requests


http(s)://rds.aliyuncs.com/? Action=ModifyCollationTimeZone
&DBInstanceId=rm-uf6wjk5xxxxxxx 
%Timezone=China Standard Time
&<Common request parameters>

Successful response examples

XML format

<ModifyCollationTimeZoneResponse> 
  <collation>Latin1_General_CI_AS</collation> 
  <dBInstanceId>rm-bp1yx1dv50269syxa</dBInstanceId> 
  <requestId>8EA054AF-DFA7-497D-9F57-790FFC974C0B</requestId> 
  <taskId>114413215</taskId> 
  <timezone>nochange</timezone> 
</ModifyCollationTimeZoneResponse> 

JSON format

{
	"taskId":"114413215",
	"timezone":"nochange",
	"requestId":"8EA054AF-DFA7-497D-9F57-790FFC974C0B",
	"collation":"Latin1_General_CI_AS",
	"dBInstanceId":"rdsaiiabnaiiabn"
}

Error codes

View error codes