gowthaman ramasamy <[EMAIL PROTECTED]> wrote:
> hello list,
> this is a MySQL realted question
>
> I have a mySQL table with 15 columns. I query that table and group
> (using GROUP_CONCAT) them based on one filed (say coloumn1). I get the
> results. But, the result is truncated in some of the lines. It gets
> truncated exactly after 1032th character of that line. Truncation
> happens in lines having more than 1032 characters.
> how can solve this ?
>
> is this 1032 is limit set by mysql or linux (i use RH 7.3). How to sort
> it out.
Check value of group_concat_max_len system variable:
SELECT @@session.group_concat_max_len;
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
