Mssql Numeric Data Type Problem

If you are having Problems getting the numeric colum types to behave well with YII you can the exactType function in framework/db/schema/mssql/CMssqlSchema.php

to *******************

protected function extractType($dbType)


{


	if(strpos($dbType,'float')!==false || strpos($dbType,'real')!==false)


		$this->type='double';


	elseif(strpos($dbType,'bigint')===false && (strpos($dbType,'int')!==false || strpos($dbType,'smallint')!==false || strpos($dbType,'tinyint')))


		$this->type='integer';


	elseif(strpos($dbType,'bit')!==false)


		$this->type='boolean';


	elseif(strpos($dbType,'numeric')!==false)


		$this->type='double';		


	else


		$this->type='string';


}