我似乎找不到一种方法,可以使用PHP5的PDO和PostgreSQL将bytea绑定到预处理语句中。这是我想象中的工作方式...
$this->stmtPDO = $this->hPDO->prepare (
'INSERT INTO board.feedback ("created", "title", "payloaddata")
VALUES (NOW(), :title, :payload) RETURNING psk;',
array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL)
);
$this->stmtPDO->bindParam(":payload", $payload);
$this->stmtPDO->bindParam(":title", $title);
$this->stmtPDO->execute();
有人找到了这个问题的简单解决方案吗?
PDO::PARAM_LOB
吗,例如$this->stmtPDO->bindParam(":payload", $payload, PDO::PARAM_LOB);
? - Milen A. Radev