Re: MySQl prints only first 1032 character in output line
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]
Re: MySQl prints only first 1032 character in output line
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
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]
MySQl prints only first 1032 character in output line
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. -- Ra. Gowthaman, Graduate Student, Bioinformatics Lab, Malaria Research Group, ICGEB , New Delhi. INDIA Phone: 91-9811261804 91-11-26173184; 91-11-26189360 #extn 314 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]