MySQL Server Forum - phpMyAdmin - limit of full text

Author

phpMyAdmin - limit of full text

David Smithz

2006-03-16, 8:23 pm

Hi there,

Just run a query that has a column that has a result of more then 1024
characters( quite a lot more actually) when I display full text in
phpMyAdmin, it only seems to show up to 1024 characters.

I was really hoping this was not the case. does anyone know how I can get
round this.

Sorry for probably not the best presented question, but under pressure to
get some reports ready for tomorrow morning.

Kind regards

David.

David Smithz

2006-03-16, 8:23 pm

> Just run a query that has a column that has a result of more then 1024
> characters( quite a lot more actually) when I display full text in
> phpMyAdmin, it only seems to show up to 1024 characters.
>
> I was really hoping this was not the case. does anyone know how I can get
> round this.
>
> Sorry for probably not the best presented question, but under pressure to
> get some reports ready for tomorrow morning.

further to my last limit, it may actually be a MySQL limit as when I changed
the query into my own php script within a HTML page it seemed to have the
same limit. I did not get anything returned over 1024 characters. How comes
this is happening and what can I do about it?

Kind regards

David.

Bill Karwin

2006-03-17, 3:23 am

"David Smithz" <dave1900@blueyonder.co.uk> wrote in message
news:GGoSf.37271$wl.582@text.news.blueyonder.co.uk...
> further to my last limit, it may actually be a MySQL limit as when I
> changed the query into my own php script within a HTML page it seemed to
> have the same limit. I did not get anything returned over 1024 characters.
> How comes this is happening and what can I do about it?

How do you know the result has more than 1024 characters?
What's the data type of the column(s) involved?
What's the query?
What version of MySQL are you using?

Here's the page that describes limits on string-related types:
http://dev.mysql.com/doc/refman/5.0...e-overview.html

Regards,
Bill K.

David Smithz

2006-03-17, 7:23 am

"Bill Karwin"
> How do you know the result has more than 1024 characters?
> What's the data type of the column(s) involved?
> What's the query?
> What version of MySQL are you using?

The query is
SELECT count(dob) as DOBcount, dob,
group_concat(concat(
firstname, ' ', lastname))
FROM accounts
GROUP BY dob
HAVING DOBcount > 1;

Which I got recently from this newsgroup. The problem is that one of the
result there are many people born on a particular day (over 1000 in fact) so
when it lists the names of 1000 people, it cuts it short at 1024 characters.

So the column type is group_concat so I assume text.
Version of MySQL is 4.1 as my host kindly upgraded so that I could use the
Group_concat command.

I'll check out the link you posted also but right now having to manually get
a list of customers on specific dates.

Thanks

noone

2006-03-17, 11:23 am

David Smithz wrote:

> "Bill Karwin"
[color=darkred]
> The query is
> SELECT count(dob) as DOBcount, dob,
> group_concat(concat(
firstname, ' ', lastname))
> FROM accounts
> GROUP BY dob
> HAVING DOBcount > 1;

> Which I got recently from this newsgroup. The problem is that one of the
> result there are many people born on a particular day (over 1000 in fact) so
> when it lists the names of 1000 people, it cuts it short at 1024 characters.

> So the column type is group_concat so I assume text.
> Version of MySQL is 4.1 as my host kindly upgraded so that I could use the
> Group_concat command.

> I'll check out the link you posted also but right now having to manually get
> a list of customers on specific dates.

> Thanks

see:
http://dev.mysql.com/doc/refman/4.1...-variables.html

System Variables (ie. set group_concat_max_len
65535 GLOBAL;)

group_concat_max_len
numeric GLOBAL | SESSION

Sponsored Links