public function testGetColumnTypeMSSql()
{
$_helper = new MssqlHelper();
$this->assertEquals("decimal(26,6)", $_helper->getColumnType("currency"));
$this->assertEquals("Unknown", $_helper->getColumnType("Unknown"));
unset($_helper);
}
/**
* @see DBHelper::getColumnType()
*/
public function getColumnType($type, $name = '', $table = '')
{
$columnType = parent::getColumnType($type, $name, $table);
if (in_array($columnType, array('char', 'varchar'))) {
$columnType = 'n' . $columnType;
}
return $columnType;
}
/**
* @see DBHelper::getColumnType()
*/
public function getColumnType($type, $name = '', $table = '')
{
$columnType = parent::getColumnType($type, $name, $table);
if (in_array($columnType, array('char', 'varchar')) && !preg_match('/(_id$|^id$)/', $name)) {
$columnType = 'n' . $columnType;
}
if (in_array($columnType, array('text', 'ntext', 'image'))) {
$columnType = 'nvarchar(max)';
}
return $columnType;
}
/**
* @see DBHelper::getColumnType()
*/
public function getColumnType($type, $name = '', $table = '')
{
$columnType = parent::getColumnType($type, $name, $table);
if (in_array($columnType, array('char', 'varchar'))) {
$columnType = 'n' . $columnType;
}
// Use varbinary field for storage of text and blob field types
//if ( in_array($columnType,array('ntext','text','image')) )
// $columnType = 'varbinary(max)';
return $columnType;
}
/**
* @see DBHelper::getColumnType()
*/
public function getColumnType($type, $name = '', $table = '')
{
$columnType = parent::getColumnType($type, $name, $table);
// Bug 30184 - Comment out this code for the time being until we have better UTF-8 support in the driver
//if ( in_array($columnType,array('char','varchar')) )
// $columnType = 'n'.$columnType;
// Bug 30876 - Comment out this code for the time being until we have better UTF-8 support in the driver
// Use varbinary field for storage of text and blob field types
//if ( in_array($columnType,array('ntext','text','image')) )
// $columnType = 'varbinary';
return $columnType;
}
