function ConnectionTest::testClientEncoding

Tests the client encoding is set to UTF8 when the connection is opened.

The client encoding is set via the DSN in \Drupal\pgsql\Driver\Database\pgsql\Connection::open(), so it is part of the connection startup packet and no "SET NAMES" query is needed.

File

core/modules/pgsql/tests/src/Kernel/pgsql/ConnectionTest.php, line 28

Class

ConnectionTest

PostgreSQL-specific connection tests.

Namespace

Code

public function testClientEncoding() : void {
  $this->assertSame('UTF8', $this->connection
    ->query('SHOW client_encoding')
    ->fetchField());
  // Ensure multi-byte UTF-8 data round trips intact.
  $string = 'héllo wörld ✓ 漢字';
  $this->assertSame($string, $this->connection
    ->query('SELECT :string::text', [
    ':string' => $string,
  ])
    ->fetchField());
  // The client encoding in the DSN must take precedence over the
  // PGCLIENTENCODING environment variable, which libpq would otherwise use
  // as the default.
  putenv('PGCLIENTENCODING=LATIN1');
  try {
    Database::addConnectionInfo('encoding_test', 'default', Database::getConnectionInfo()['default']);
    $connection = Database::getConnection('default', 'encoding_test');
    $this->assertSame('UTF8', $connection->query('SHOW client_encoding')
      ->fetchField());
  } finally {
    putenv('PGCLIENTENCODING');
    Database::closeConnection('default', 'encoding_test');
  }
}