Сохранение бинарных данных в базу
Добавлено: 2018.08.22, 18:04
$eSignData = addslashes($eSignData); //бинарник
$sql = "exec [tempdb].[dbo].[user_ESign_Get_Sing_Singl_File] :AutoCard, :pId, :IdFirm, :DocID, :StorageDocID, :DocType, :ESignData";
$command = Yii::$app->db->createCommand($sql, [
':AutoCard' => $autoCard,
':pId' => $pId,
':IdFirm' => $idFirm,
':DocID' => $docId,
':StorageDocID' => $storageDocId,
':DocType' => $docType,
':ESignData' => $eSignData,
]);
echo $content = $command->execute();
К сожалению получаю ошибку PDOException: SQLSTATE[IMSSP]: An error occurred translating string for input param 7 to UCS-2
$sql = "exec [tempdb].[dbo].[user_ESign_Get_Sing_Singl_File] :AutoCard, :pId, :IdFirm, :DocID, :StorageDocID, :DocType, :ESignData";
$command = Yii::$app->db->createCommand($sql, [
':AutoCard' => $autoCard,
':pId' => $pId,
':IdFirm' => $idFirm,
':DocID' => $docId,
':StorageDocID' => $storageDocId,
':DocType' => $docType,
':ESignData' => $eSignData,
]);
echo $content = $command->execute();
К сожалению получаю ошибку PDOException: SQLSTATE[IMSSP]: An error occurred translating string for input param 7 to UCS-2