Help Center> Relational Database Service> API Reference> API v3 (Recommended)> DB Instance Management> Querying the Available SQL Server Character Set
View PDF

Querying the Available SQL Server Character Set

Function

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

URI

  • URI format

    GET https://{Endpoint}/v3/{project_id}/collations

  • Example

    https://rds.cn-north-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/collations

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

Request

None

Response

  • Normal response
    Table 2 Parameter description

    Name

    Type

    Description

    charSets

    List<String>

    Indicates the character set information list.
  • 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

For details, see Status Codes.

Error Code

For details, see Error Codes.

Parent topic: DB Instance Management