MySQL PDO在获取时的最大LONGBLOB数据长度 [英] Mysql PDO maximum LONGBLOB data length on fetch

问题描述

我将大约1.1 Mb的数据插入到LONGBLOB类型的Mysql字段中.这与LONGBLOB字段的最大支持长度相去甚远.

I insert about 1.1 Mb of Data into a Mysql Field of type LONGBLOB. This is far away from the maximum supported length of a LONGBLOB field.

插入似乎起作用.

如果我在插入strlen($data)之前执行了strlen($data)，则返回1059245.

If I do a strlen($data) before inserting it returns 1059245.

如果我在插入后进行查询:

If i do a query after inserting:

SELECT OCTET_LENGTH(`data`)...

返回1059245

但是，如果我这样做

$stmt = $pdo->prepare("SELECT `data` FROM `tbl_mytable` WHERE `id` = :id LIMIT 1");
$stmt->bindValue(":id", $id, PDO::PARAM_INT);
$stmt->execute();
$data = $stmt->fetch(PDO::FETCH_ASSOC);
echo strlen($data['data']);

它返回1048576

it returns 1048576

我的数据似乎在1048576字节后被削减了.

My data seems to be cutten after 1048576 bytes.

为什么在执行查询时我只收到数据的前1048576个字节?

Why do I only receive the first 1048576 bytes of my data when doing a query?

它是PDO配置，类似于max_fetch_length吗?

Is it a PDO Configuration, something like max_fetch_length?

推荐答案

这是MYSQL_ATTR_MAX_BUFFER_SIZE，默认情况下为1MB.

It was the MYSQL_ATTR_MAX_BUFFER_SIZE which is 1MB by default.

此问题已解决:

    $pdo->setAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE, 1024*1024*50);  // 50 MB      

这篇关于MySQL PDO在获取时的最大LONGBLOB数据长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！