SqlserverStatement.php 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. /**
  3. * CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
  4. * Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
  5. *
  6. * Licensed under The MIT License
  7. * For full copyright and license information, please see the LICENSE.txt
  8. * Redistributions of files must retain the above copyright notice.
  9. *
  10. * @copyright Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
  11. * @link https://cakephp.org CakePHP(tm) Project
  12. * @since 3.0.0
  13. * @license https://opensource.org/licenses/mit-license.php MIT License
  14. */
  15. namespace Cake\Database\Statement;
  16. use PDO;
  17. /**
  18. * Statement class meant to be used by an Sqlserver driver
  19. *
  20. * @internal
  21. */
  22. class SqlserverStatement extends PDOStatement
  23. {
  24. /**
  25. * The SQL Server PDO driver requires that binary parameters be bound with the SQLSRV_ENCODING_BINARY attribute.
  26. * This overrides the PDOStatement::bindValue method in order to bind binary columns using the required attribute.
  27. *
  28. * {@inheritDoc}
  29. */
  30. public function bindValue($column, $value, $type = 'string')
  31. {
  32. if ($type === null) {
  33. $type = 'string';
  34. }
  35. if (!ctype_digit($type)) {
  36. list($value, $type) = $this->cast($value, $type);
  37. }
  38. if ($type == PDO::PARAM_LOB) {
  39. $this->_statement->bindParam($column, $value, $type, 0, PDO::SQLSRV_ENCODING_BINARY);
  40. } else {
  41. $this->_statement->bindValue($column, $value, $type);
  42. }
  43. }
  44. }