for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace Yiisoft\Db\Mssql;
use Yiisoft\Db\Expression\Expression;
use Yiisoft\Db\Schema\ColumnSchema as AbstractColumnSchema;
use function substr;
/**
* Class ColumnSchema for MSSQL database
*/
final class ColumnSchema extends AbstractColumnSchema
{
* Prepares default value and converts it according to {@see phpType}.
*
* @param mixed $value default value
* @return mixed converted value
public function defaultPhpTypecast($value)
if ($value !== null) {
/** convert from MSSQL column_default format, e.g. ('1') -> 1, ('string') -> string */
$value = substr(substr($value, 2), 0, -2);
}
return $this->phpTypecast($value);
public function dbTypecast($value)
if (
$this->getType() === Schema::TYPE_BINARY &&
$this->getDbType() === 'varbinary' &&
is_string($value)
) {
return new Expression('CONVERT(VARBINARY(MAX), ' . ('0x' . bin2hex($value)) . ')');
return parent::dbTypecast($value);
yiisoft /
db-mssql
