MySQL - Exceeding VARCHAR length from SELECT statement

Question

SELECT GROUP_CONCAT(DISTINCT(fullname) SEPARATOR ';')AS "FULLNAMES"
  FROM Users;

I want to retrieve the fullnames of Users in a single row. However, the statement gives an incomplete result returning only the first 254 characters.

Is it possible to surpass this limitation?

Some might suggest to use the statement below instead and iterate through the result in my application but there's something that I would like to know.

SELECT DISTINCT fullname
  FROM Users;

Do I have to restart the database for the changes to take effect? (Sorry if I didn't try before I asked. Someone is using the same instance as mine) — Michael 'Maik' Ardan, Jun 29 '14 at 05:24
I think it's at the session level, so you don't need to worry about other people — Fabricator, Jun 29 '14 at 05:27

score 1 · Accepted Answer · answered Jun 29 '14 at 05:13

1

Try adjusting the value of group_concat_max_len

answered Jun 29 '14 at 05:13

Collin Grady

2,226
1
14
14

MySQL - Exceeding VARCHAR length from SELECT statement

1 Answers1