Work with SQL Server, using pdo_sqlsrv driver (PHP 5.4)
In my DB I have column with varbinary
type and size of 7584.
When I try to get value from this column I get this error
Invalid sql_display_size in G:\..\..\..\framework\yiilite.php on line 8836
Here is the query:
DECLARE @item varbinary(1728); SET @item = (SELECT Inventory FROM Character WHERE Name='CharName'); print @item;
In this case I get exactly that size that I need. It work in normal php query (not PDO) and in SQL Server Management Studio.
When I run this code in Yii:
$query = "DECLARE @item varbinary(1728); SET @item = (SELECT Inventory FROM Character WHERE Name='CharName'); print @item";
$command=Yii::app()->db->createCommand($query)->query();
$command->read();
I get this:
SQLSTATE[IMSSP]: The active result for the query contains no fields.
I think that I built a wrong query.
My question is, How to run a query like this in Yii ?