Re: MySQl prints only first 1032 character in output line

2004-03-25 Thread Victoria Reznichenko 
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]

Re: MySQl prints only first 1032 character in output line

2004-03-25 Thread gowthaman ramasamy 
On Thu, 2004-03-25 at 21:23, Victoria Reznichenko wrote:
thank you dear victoria
it says 1024. How can i increase it?.

 
 Check value of group_concat_max_len system variable:
 
   SELECT @@session.group_concat_max_len;





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQl prints only first 1032 character in output line

2004-03-25 Thread Victoria Reznichenko 
gowthaman ramasamy [EMAIL PROTECTED] wrote:
 On Thu, 2004-03-25 at 21:23, Victoria Reznichenko wrote:
 thank you dear victoria
 it says 1024. How can i increase it?.

Use SET command. For example:

SET @@global.group_concat_max_len=5000;
or
SET @@session.group_concat_max_len=5000;


 
 
 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]