Help Center/ Relational Database Service/ API Reference/ API v3 (Recommended)/ Database and Account Management (Microsoft SQL Server)/ Querying the Available SQL Server Character Set
Updated on 2025-12-09 GMT+08:00
View PDF
Share

Querying the Available SQL Server Character Set

Function

This API is used to query the SQL Server character set list.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.
  • If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action

Access Level

Resource Type (*: required)

Condition Key

Alias

Dependencies

rds:database:list

list

instance

-g:EnterpriseProjectId

- g:ResourceTag/<tag-key>

-

-

URI

  • URI format

    GET /v3/{project_id}/collations

  • Parameter description
    Table 1 Parameters

    Parameter

    Mandatory

    Description

    project_id

    Yes

    Definition

    Project ID of a tenant in a region.

    To obtain the value, see Obtaining a Project ID.

    Constraints

    N/A

    Range

    N/A

    Default Value

    N/A

Request

  • Request parameters

    None

  • URI example

    GET https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/collations

Response

  • Normal response
    Table 2 Parameters

    Parameter

    Type

    Description

    charSets

    List<String>

    Definition

    Indicates the character set information list.

    Range

    N/A
  • Example normal response 
    {
	"charSets": ["Chinese_PRC_CI_AS", "SQL_Latin1_General_CP1_CI_AS", "French_BIN", "Chinese_PRC_Stroke_BIN", "Chinese_PRC_CI_AI"]
}
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

Error Code

For details, see Error Codes.