MySQL Forums
Forum List  »  Knowledge Base

Re: Problem with data view - values of calculated field are too long
Posted by: Do Trung
Date: October 01, 2009 02:53AM

Actually the problem is derived from the nature of GROUP_CONCAT():

"The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the effective maximum length of the return value is constrained by the value of max_allowed_packet. The syntax to change the value of group_concat_max_len at runtime is as follows, where val is an unsigned integer:

SET [GLOBAL | SESSION] group_concat_max_len = val;"

Reference: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat
I got the answer from this source: http://stackoverflow.com/questions/529105/trouble-with-concat-and-longtext

Hope this help.

Best regards,

.Viet Trung.



Edited 1 time(s). Last edit at 10/01/2009 02:55AM by Do Trung.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem with data view - values of calculated field are too long
1995
October 01, 2009 02:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.