473,320 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

phpMyAdmin - limit of full text

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.
Mar 17 '06 #1
4 5928
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.
Mar 17 '06 #2
"David Smithz" <da******@blueyonder.co.uk> wrote in message
news:GG****************@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/...-overview.html

Regards,
Bill K.
Mar 17 '06 #3

"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

Mar 17 '06 #4
David Smithz wrote:

"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


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

Mar 17 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

30
by: Darren Gates | last post by:
hi PHP users, Here's a Flash 7 version of phpMyAdmin: http://www.tufat.com/phpflashmyadmin.php Special features include: drag-and-drop interface for InnoDB table relationships, quick record...
0
by: ghasem | last post by:
Dear all, Hello to all the great minds of php. My humble question is regarding the phpmyadmin. As you know the welcome screen of phpmyadmin allows one to choose the language. My question is this:...
0
by: Ed | last post by:
------=_NextPart_000_001D_01C34FCC.1D2B5E50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable There seems to be a significant penalty imposed by the...
1
by: lithne | last post by:
Hi, when I try to open phpMyAdmin administration page I got this error: 'Cannot load mysql extension, please check your PHP configuration' I cannot sort out what's the source of the problem,...
2
by: news | last post by:
We just upgraded our phpMyAdmin GUI to the latest stable version, and now the SQL queries are doing odd additions. First, without changing the database it's connecting to at all, there's a new...
1
by: stbrenner | last post by:
Hi, I'm trying to insert 5112 lines of data into a table named INVENTORY via phpmyadmin. All the data types are CHAR and have a limit of 50 (there are 8 columns). I tried inserting the data by...
0
by: NewbieSupreme | last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer...
5
by: Marcus | last post by:
Hello, I am having a problem with a query in phpMyAdmin... it works fine on my localhost, but the exact same query produces an error in phpMyAdmin on my server: localhost: PHP 4.3.11, MySQL...
0
by: northernrave | last post by:
Hi, I am new to PHP and I can only understand small bits and pieces. I have ordered a dedicated server running on a linux operating system and I have just installed PHPmyadmin. When I tried to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.