How to retrieve large data from mysql to php?

Question

How can I retrieve large data from mysql to php? I've tried, but I'm getting a 1048576 characters string and my row is bigger than that.

Answer 1

Ok, so thanks to Pablo Jiménez, that was quick.

Pdo's buffer was indeed too small, by doing so i was able to retrieve my data.

$pdo = new PDO(
$dsn,
$username,
$password,
array(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE => 2097152)

);