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 2024-06-07 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.

  • Before calling an API, you need to understand the API in Authentication.

URI

  • URI format

    GET /v3/{project_id}/collations

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Project ID of a tenant in a region.

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

Request

  • Request parameters

    None

  • URI example

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

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

Error Code

For details, see Error Codes.