Queries the attributes that are supported by PolarDB for Oracle or PolarDB for PostgreSQL databases, such as the character sets and collations.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String No DescribeDBInitializeVariable

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

DBClusterId String Yes pc-****************

The ID of the cluster.

Note You can call the DescribeDBClusters operation to query information about all the clusters that are deployed in a specified region, including the cluster IDs.

Response parameters

Parameter Type Example Description
DBType String PostgreSQL

The type of the database. Valid values:

  • Oracle
  • PostgreSQL
DBVersion String 11

The version of the database.
RequestId String 475F58B7-F394-4394-AA6E-4F1CBA******

The ID of the request.
Variables Array of Variable

The returned data.
Variable
Charset String EUC_CN

The supported character set.
Collate String C

The collation that is used to sort strings.
Ctype String C

The type of the character.

Examples

Sample requests

http(s)://polardb.aliyuncs.com/? Action=DescribeDBInitializeVariable
&DBClusterId=pc-****************
&<Common request parameters>

Sample success responses

XML format 

<ResponseResponse>
      <Variables>
            <Variable>
                  <Charset>EUC_CN</Charset>
                  <Collate>C</Collate>
                  <Ctype>C</Ctype>
            </Variable>
            <Variable>
                  <Charset>EUC_CN</Charset>
                  <Collate>POSIX</Collate>
                  <Ctype>POSIX</Ctype>
            </Variable>
      </Variables>
      <DBVersion>11</DBVersion>
      <RequestId>475F58B7-F394-4394-AA6E-4F1CBA1F2FE8</RequestId>
      <DBType>PostgreSQL</DBType>
</ResponseResponse>

JSON format 

{
  "Variables": {
    "Variable": [      
        {
            "Charset": "EUC_CN",
            "Collate": "C",
            "Ctype": "C"
        },
        {
            "Charset": "EUC_CN",
            "Collate": "POSIX",
            "Ctype": "POSIX"
        }
      ]
  },
  "DBVersion": "11",
  "RequestId": "475F58B7-F394-4394-AA6E-4F1CBA1F2FE8",
  "DBType": "PostgreSQL"
}

Error codes

For a list of error codes, visit the API Error Center.