問(wèn)題描述
我將大約 1.1 Mb 的數(shù)據(jù)插入到 LONGBLOB 類(lèi)型的 Mysql 字段中.這與 LONGBLOB 字段支持的最大長(zhǎng)度相差甚遠(yuǎn).
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.
插入似乎有效.
如果我在插入之前執(zhí)行 strlen($data) 返回 1059245.
If I do a strlen($data) before inserting it returns 1059245.
如果我在插入后進(jìn)行查詢(xún):
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
我的數(shù)據(jù)似乎在 1048576 字節(jié)后被截?cái)嗔?
My data seems to be cutten after 1048576 bytes.
為什么我在查詢(xún)時(shí)只收到數(shù)據(jù)的前 1048576 個(gè)字節(jié)?
Why do I only receive the first 1048576 bytes of my data when doing a query?
它是 PDO 配置，類(lèi)似于 max_fetch_length 嗎?
Is it a PDO Configuration, something like max_fetch_length?
推薦答案
MYSQL_ATTR_MAX_BUFFER_SIZE 默認(rèn)為 1MB.
It was the MYSQL_ATTR_MAX_BUFFER_SIZE which is 1MB by default.
這解決了問(wèn)題:
$pdo->setAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE, 1024*1024*50); // 50 MB
這篇關(guān)于獲取時(shí)Mysql PDO最大LONGBLOB數(shù)據(jù)長(zhǎng)度的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！