function SchemaTest::assertCollation

Asserts that fields have the correct collation, if supported.

Overrides DriverSpecificSchemaTestBase::assertCollation

File

core/modules/mysql/tests/src/Kernel/mysql/SchemaTest.php, line 36

Class

SchemaTest

Tests schema API for the MySQL driver.

Namespace

Code

protected function assertCollation() : void {
  // Make sure that varchar fields have the correct collations.
  $columns = $this->connection
    ->query('SHOW FULL COLUMNS FROM {test_table}');
  foreach ($columns as $column) {
    if ($column->Field == 'test_field_string') {
      $string_check = $column->Collation;
    }
    if ($column->Field == 'test_field_string_ascii') {
      $string_ascii_check = $column->Collation;
    }
  }
  $this->assertMatchesRegularExpression('#^(utf8mb4_general_ci|utf8mb4_0900_ai_ci)$#', $string_check, 'test_field_string should have a utf8mb4_general_ci or a utf8mb4_0900_ai_ci collation, but it has not.');
  $this->assertSame('ascii_general_ci', $string_ascii_check, 'test_field_string_ascii should have a ascii_general_ci collation, but it has not.');
}