php - Cakephp Sqlserver编码

Question

这让我难住了。我正在尝试为我的 Sqlserver 连接设置编码，但我尝试的所有操作都失败了。我只得到

Error: A Database connection using "Sqlserver" was missing or unable to connect.
The database server returned this error: SQLSTATE[IMSSP]: An invalid encoding was specified for SQLSRV_ATTR_ENCODING.

我试图通过编码解决的原始错误是:

Error: SQLSTATE[IMSSP]: An error occurred translating the query string to UTF-16: No mapping for the Unicode character exists in the target multi-byte code page.

SQL版本为2008 R2
Cakephp版本:2.4.2
PHP版本:5.3.27

Answer 1

经过大量的试验和错误后，这是可行的:

public $default = array(
    'datasource'    => 'Database/Sqlserver',
    'persistent'    => false,
    'host'      => 'localhost',
    'login'     => 'sa',
    'password'  => 'password',
    'database'  => 'SchedulingDatabase',
    'encoding'  => PDO::SQLSRV_ENCODING_UTF8
);