Set group_concat_max_len on a PDO query

Question

I have the following query:

$cases = $conn->prepare("SELECT GROUP_CONCAT(text SEPARATOR '|') as texts, year FROM cases GROUP BY year ORDER BY ano DESC");
$cases->execute();
$cases_result = $cases->fetchAll(PDO::FETCH_OBJ);

But some texts are not showing completely

So I have to change the value of group_concat_max_len. I did as follows:

mysql_query("SET group_concat_max_len = 2048");

But using PDO not know how

castis · Accepted Answer · 2017-01-31T21:18:53.990

15

Can you not use $conn->query()?

$conn->query("SET group_concat_max_len = 2048");

edited Jan 31 '17 at 21:18

answered Aug 09 '13 at 18:33

castis

8,154
4
41
63

Thanks. Is there a maximum value? – user2668863 Aug 09 '13 at 18:37
3

yeah, 4,294,967,295 for 32 bit platforms and 18,446,744,073,709,547,520 for 64 bit. – castis Aug 09 '13 at 18:39

Set group_concat_max_len on a PDO query

1 Answers1

Linked

Related