Character Limit

[honkmaster]

Hi, I running a query that groups merge.Description where the StoreId is the same, and replacing the comma with a line break.

The problem I'm getting is the string only returns 1023 character's and I need it to return more?

Any help would be great

Cheers

 

$rows = mysql_query("SELECT  REPLACE(GROUP_CONCAT(merge.Description), ',', CHAR(13)) FROM merge GROUP BY merge.StoreId");

 

[Barand]

SELECT GROUP_CONCAT(merge.Description SEPARATOR '\n') ...

Why the REPLACE() malarky? Just use the SEPARATOR option in GROUP_CONCAT().

SET @@group_concat_max_len = whatever;