cakephp/src/Database/Statement/SqlserverStatement.php

<?php
/**
 * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 * @link          http://cakephp.org CakePHP(tm) Project
 * @since         3.0.0
 * @license       http://www.opensource.org/licenses/mit-license.php MIT License
 */
namespace Cake\Database\Statement;

use Cake\Database\Statement\PDOStatement;
use PDO;

/**
 * Statement class meant to be used by an Sqlserver driver
 *
 * @internal
 */
class SqlserverStatement extends PDOStatement {

/**
 * The SQL Server PDO driver requires that binary parameters be bound with the SQLSRV_ENCODING_BINARY attribute.
 * This overrides the PDOStatement::bindValue method in order to bind binary columns using the required attribute.
 *
 * {@inheritDoc}
 */
	public function bindValue($column, $value, $type = 'string') {
		if ($type === null) {
			$type = 'string';
		}
		if (!ctype_digit($type)) {
			list($value, $type) = $this->cast($value, $type);
		}
		if ($type == PDO::PARAM_LOB) {
			$this->_statement->bindParam($column, $value, $type, 0, PDO::SQLSRV_ENCODING_BINARY);
		} else {
			$this->_statement->bindValue($column, $value, $type);
		}
	}
}