I am also getting the same error, I tried the above solutions but none worked...

Contribution Date

Fri, 07/19/2019 - 12:00

Technology

Drupal

Contribution Project

Drupal driver for SQL Server and SQL Azure

Contribution Details

I am also getting the same error, I tried the above solutions but none worked.

I am using Drupal 8.7.3 version.

In file docroot/drivers/lib/Drupal/Driver/Database/sqlsrv/Connection.php, I tried changing insecure options to true but then i started getting below error on every drush command.

// Merge default statement options. These options are
    // only specific for this preparation and will only override
    // the global configuration if set to different than NULL.
    $options = array_merge(array(
        'insecure' => TRUE,
        'statement_caching' => $this->driver_settings->GetStatementCachingMode(),
        'direct_query' => $this->driver_settings->GetDefaultDirectQueries(),
        'prefix_tables' => TRUE,
        'integrityretry' => FALSE,
        'resilientretry' => TRUE,
      ), $options);

The error was "An error occurred translating the query string to UTF-16: No mapping for the Unicode character exists in the target multi-byte code page." in docroot/drivers/lib/Drupal/Driver/Database/sqlsrv/mssql/src/Statement.php:312

Issue Status

Needs work

Contribution Author

rajeevgole

Contribution Issue Link

2100 parameter limit issue

Contribution Link

https://www.drupal.org/project/sqlsrv/issues/2779047#comment-13188889

Files count

0

Patches count

0