Re: Problem with data view - values of calculated field are too long

[Do Trung]

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.