Cakephp Sqlserver encoding

Question

This has me stumped. I am trying to set encoding for my Sqlserver connection and all that I have tried has failed. I only get

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.

The original error I was trying to solve through encoding is:

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.

The SQL version is 2008 R2
Cakephp Version: 2.4.2
PHP Version: 5.3.27

It seems like an error within your SQL Server try to use utf-8 instead and see if the problem persists. — Nikel Weis
– Nikel Weis, Commented Nov 18, 2013 at 8:57

user2458157 · Accepted Answer · 2013-11-20 03:29:39Z

10

After a lot of trial and error this works:

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

answered Nov 20, 2013 at 3:29

user2458157

Sign up to request clarification or add additional context in comments.

Comments

Álvaro González · Accepted Answer · 2016-09-07 12:19:50Z

6

Tried this out with Cakephp 3.0 seems to work nicely.

'Datasources' => [
    'default' => [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Sqlserver',
        'persistent' => false,
        'host' => 'localhost',
        'port' => '1433', //using this port
        'username' => 'sa',
        'password' => 'password',
        'database' => 'cake_bookmarks',
        'encoding' => PDO::SQLSRV_ENCODING_UTF8,
        'timezone' => 'UTC',
        'cacheMetadata' => true,
        'quoteIdentifiers' => false,
    ]

edited Sep 7, 2016 at 12:19

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

answered Apr 3, 2015 at 21:37

mmv_sat

4568 silver badges15 bronze badges

Comments

theMojoWill · Accepted Answer · 2013-11-19 10:06:43Z

0

SQL 2008 doesn't support UTF-16 only SQL 2012

http://msdn.microsoft.com/en-us/library/ms143726(v=sql.110).aspx

UTF-8 isn't supported at all by MS SQL.

answered Nov 19, 2013 at 10:06

theMojoWill

761 gold badge2 silver badges9 bronze badges

1 Comment

Gonzalo Bahamondez Over a year ago

So sad ;_;, use mysql or postgres.

Collectives™ on Stack Overflow

Cakephp Sqlserver encoding

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related