List available MySQL character sets and collations, optionally filtered by a MySQL version

GET/mysql-charsets/

API version

v2

Request method

GET

Operation ID

database-list-mysql-charsets

---

Request

Responses

Format

application/json

Description

OK

Schema documentation

• Array[
• *object
  • collationsarray of string

    required
    • Array[
    • *string
    ]
• namestring

  required
• versionIdstring

  required

]

Example

Content-Type: application/json

[
  {
    "collations": [
      "utf8_general_ci",
      "utf8_bin",
      "utf8_unicode_ci"
    ],
    "name": "utf8",
    "versionId": "mysql57"
  }
]

JSON Schema

{
  "items": {
    "properties": {
      "collations": {
        "example": [
          "utf8_general_ci",
          "utf8_bin",
          "utf8_unicode_ci"
        ],
        "items": {
          "type": "string"
        },
        "type": "array"
      },
      "name": {
        "example": "utf8",
        "type": "string"
      },
      "versionId": {
        "example": "mysql57",
        "type": "string"
      }
    },
    "required": [
      "name",
      "collations",
      "versionId"
    ],
    "type": "object"
  },
  "type": "array"
}

Usage examples

cURL

$ curl \
    --fail \
    --location \
    -H "Authorization: Bearer $MITTWALD_API_TOKEN" \
    https://api.mittwald.de/v2/mysql-charsets?version=string

JavaScript SDK

import { MittwaldAPIV2Client } from "@mittwald/api-client";
import { assertStatus } from "@mittwald/api-client-commons";
  
const client = MittwaldAPIClient.newWithToken(process.env.MITTWALD_API_TOKEN);
const response = await client.database.listMysqlCharsets({
  "queryParameters": {
    "version": "string"
  }
});

assertStatus(response, 200);
  

PHP SDK

use \Mittwald\ApiClient\Generated\V2\Clients\Database\ListMysqlCharsets\ListMysqlCharsetsRequest;
  
$client = MittwaldAPIClient::newWithToken(getenv('MITTWALD_API_TOKEN'));

$request = (new ListMysqlCharsetsRequest())
  ->withVersion("string");
$response = $client->database()->listMysqlCharsets($request);

var_dump($response->getBody();