RE: group_concat display limit

is the size of the VARCHAR field -Original Message- From: Andrey Dmitriev [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 08, 2008 12:34 AM To: mysql@lists.mysql.com Subject: group_concat display limit All, We are using group_concat but there seems to be some sort of display limit

group_concat display limit

All, We are using group_concat but there seems to be some sort of display limit. Is there are a way to unset or increase it? Thanks, Andrey

Re: group_concat display limit

You should change your sql to related sub query. On Jan 8, 2008 1:34 PM, Andrey Dmitriev [EMAIL PROTECTED] wrote: All, We are using group_concat but there seems to be some sort of display limit. Is there are a way to unset or increase it? Thanks, Andrey -- I'm a mysql DBA in china.

Re: group_concat display limit

Andrey Dmitriev wrote: All, We are using group_concat but there seems to be some sort of display limit. Is there are a way to unset or increase it? Thanks, Andrey You can change the maximum length by setting the group_concat_max_len system variable to a higher value which is

Re: group_concat display limit

learnt. On Jan 8, 2008 2:11 PM, Werner Puschitz [EMAIL PROTECTED] wrote: Andrey Dmitriev wrote: All, We are using group_concat but there seems to be some sort of display limit. Is there are a way to unset or increase it? Thanks, Andrey You can change the maximum length by