php - 对于 MySQL TEXT 类型，我应该使用 PDO PARAM_LOB 还是 PARAM_STR？

Question

对于 MySQL TEXT 类型，我应该使用 PDO PARAM_LOB 还是 PARAM_STR？我希望我的数据超过 5000 个字符。

$stmt->bindParam(':notes', $notes, PDO::PARAM_STR);

或

$stmt->bindParam(':notes', $notes, PDO::PARAM_LOB);

Answer 1

如果您要使用大块数据，正如您在用例中提到的，那么是的——我会使用 PDO::PARAM_LOB 来使用 data 操作您的数据流。

根据PHP documentation :

At some point in your application, you might find that you need to store "large" data in your database. Large typically means "around 4kb or more", although some databases can happily handle up to 32kb before data becomes "large". Large objects can be either textual or binary in nature. PDO allows you to work with this large data type by using the PDO::PARAM_LOB type code in your PDOStatement::bindParam() or PDOStatement::bindColumn() calls. PDO::PARAM_LOB tells PDO to map the data as a stream, so that you can manipulate it using the PHP Streams API.

像这样使用它:

<?php
$db = new PDO('odbc:SAMPLE', 'db2inst1', 'ibmdb2');
$stmt = $db->prepare("select contenttype, imagedata from images where id=?");
$stmt->execute(array($_GET['id']));
$stmt->bindColumn(1, $type, PDO::PARAM_STR, 256);
$stmt->bindColumn(2, $lob, PDO::PARAM_LOB);
$stmt->fetch(PDO::FETCH_BOUND);

header("Content-Type: $type");
fpassthru($lob);